End date calculation ignoring weekends?

[CHRISTOPHE_CHAN]

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 ?

[MultiTech]

Check out

help.appsheet.com

WORKDAY()

Computed date excluding non-work days

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

[CHRISTOPHE_CHAN]

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]

[Aleksi]

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

[CHRISTOPHE_CHAN]

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

[Steve · Accepted solution]

CHRISTOPHE_CHANDELIE:

The next monday whatever the reference date is.

Try:

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

[CHRISTOPHE_CHAN]

Thanks for the expression, working fine !