End date calculation ignoring weekends?

AppSheet AppSheet Q&A
1

Hi,

Is there any possibility to calculate an end date, from a definite start date and a duration (in days) but ignoring saturdays and sundays ?

2

Check out

2X_3_3b45f1abff9656bbb2d02db7f0ec059dd473cf0c.png

1 Like
3

Thanks this one was easy I could have found it myself sorry. Related though, could you precise in this expression what [Weekday] is related to ? I tried [2] for monday but seems to be wrong.

What I need is getting the next monday, from a definite date.

([Date] + MOD(([Weekday] - WEEKDAY([Date]) + 7), 7)) : Date of the first [Weekday] on or after [Date]

4

What do you actually need… the next moday what ever the date is today or just the next workday?

5

The next monday whatever the reference date is. This ref date is not today. It’s calculated with today()+ 90 for exemple.

6

CHRISTOPHE_CHANDELIE:

The next monday whatever the reference date is.

Try:

([Date] - WEEKDAY([Date]) + 2 + 7)
3 Likes
7

Thanks for the expression, working fine !

1 Like