Dateadd function to give a later date

[eWise]

Hi all,

I have a datetime column and I need an adjusted datetime column where if an entry falls on a saturday, the adjusted datetime goes to the following Monday 9 a.m. else the datetime remains remains unchanged like below. 

DayOfWeek	DateTime	AdjustedDateTime
Sat	4/10/2021 11:00	4/12/2021 9:00
Mon	3/29/2021 9:20	3/29/2021 9:20

Thanks for the help. 

[Fowmy]

@eWise 

You can add the following calculated column to your table:

Adjusted DateTime = 

IF(
    WEEKDAY([DateTime]) = 7,
    INT([DateTime]) + 2 + TIME(9,0,0),
    [DateTime]
)

[eWise · Accepted solution]

Thank you @Fowmy It worked perfectly.