SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE FUNCTION dbo.WeekDayOrWeekEnd (@input datetime)
RETURNS VARCHAR(250)
AS BEGIN
    DECLARE @Result VARCHAR(250)

    SET @Result =CASE WHEN DATEPART(dw,@input) IN (1,2) THEN 'Weekend' ELSE 'Weekday' END
    RETURN @Result
END
CREATE PROCEDURE dates 
AS
BEGIN
    DECLARE @startdate smalldatetime;
    DECLARE @dateafteryear smalldatetime;
    DECLARE @weekafter smalldatetime;
    DECLARE @daylater smalldatetime;

    SET @startdate = getdate();
    SET @dateafteryear = DATEADD(YYYY,1,@startdate)
    SET @weekafter = DATEADD(week,1,@startdate)
    SET @daylater = DATEADD(day,1,@startdate)

    print 'Original Date ' + CAST(@startdate AS VARCHAR)+' is a '+ [dbo].WeekDayOrWeekEnd(@startdate)
    print 'A year later ' + CAST(@dateafteryear AS VARCHAR)+' is a '+ [dbo].WeekDayOrWeekEnd(@dateafteryear)
    print 'A week later ' + CAST(@weekafter AS VARCHAR)+' is a '+ [dbo].WeekDayOrWeekEnd(@weekafter)
    print 'A day later ' + CAST(@daylater AS VARCHAR) +' is a '+ [dbo].WeekDayOrWeekEnd(@daylater)

END
EXEC dates;
Original Date Jul 16 2021  5:40AM is a Weekday
A year later Jul 16 2022  5:40AM is a Weekday
A week later Jul 23 2021  5:40AM is a Weekday
A day later Jul 17 2021  5:40AM is a Weekday