Forum Discussion

skv17's avatar
skv17
Icon for Helper II rankHelper II
2 years ago
Solved

Skip Weekends when adding date

I have two column - Start Date and Days required to deliver.   So if Start Date is 13/10/2023 which is on a friday and Days required to deliver is 2,so I need a new column called Arrival cut off da...
Need Help
Show and Tell
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

and try this

 

 

List.Max( List.Range( List.Select(
List.Generate(()=>
 [Start Date],(x)=>x<=Date.AddDays([Start Date],[Day]*5),  (x)=> Date.AddDays(x,1)), (x)=>  not (Date.DayOfWeek(x) =5   or Date.DayOfWeek(x) =6 or x=[Start Date])),0,[Day]))