Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated End Date Based on Weekend

Hi all,

 

I have a data set similar to the one below

 

Start DateDuration (Days)
01/01/20216
02/01/20217
01/02/20214

 

I want to create a calculated column titled 'End Date'. This end date needs to exclude weekends.

 

For example, if a task was to start on 24/05/2021 (Monday) and had a duration of 6 days. I would need the end date to be 31/05/2021 (Monday). 

 

Any help would be much appreciated.

 

Thanks,

 

Elliot