Calculate End Date Excluding Weekends

[Anonymous]

Hi,

I have a dataset that is similar to the below.

Start Date	Duration (Days)
01/01/2023	1
01/02/2023	5
01/03/2023	23

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 🙂 

[Ahmedx · Accepted solution]

Refer to this solution

https://community.fabric.microsoft.com/t5/Desktop/Skip-Weekends-when-adding-date/m-p/3498583#M115701...