Add days to a date, excluding weekend

[bondy_07]

Hi there, I am trying to add 1 day to a datefield Chockersdate, excluding Weekends.

Thanks in advance!

[RezaDorrani · Accepted solution]

Hi @bondy_07 

use expressions

if( equals(dayOfWeek(addDays(utcNow(),1)),'5'),addDays(utcNow(),3),if( equals(dayOfWeek(addDays(utcNow(),1)),'6'),addDays(utcNow(),2),addDays(utcNow(),1)))

you can replace utcNow() with your datefield value

above code will check - if day of week is 5 (friday) - add 3 days

if day of week is 6 (saturday) - add 2 days

else add 1 day

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly