Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate End Date Excluding Weekends

Hi,

 

I have a dataset that is similar to the below.

 

Start DateDuration (Days)
01/01/20231
01/02/20235
01/03/202323

 

I need to create a calculated column to show the end date. This end date must be the start date + duration whilst excluding weekends.

 

For example if the start date fell on a friday and had a duration of two days, the end date would fall on the coming monday.

 

Many thanks 🙂