Forum Discussion
calculate date without holidays (only working days)
- 3 years ago
jcamilo1985 I am afraid I can't comment on this. Probably because my function uses recursive call. I don't know. It's quite easy to reproduce this function using List.Generate. I'll try to do that a bit later, mate.
- 3 years ago
Thank you very much for your commitment and interest in this topic AlienSx .
After several attempts, I was finally able to find the solution, but all thanks to the base that you gave me.Here I share it in case someone else needs it at some point.
In the same way thanks to the other people who read the thread and were interested.(start as date, days as number, holidays as list) as date => let dates = List.Generate( () => [ date = start, count = 1, holiday = List.Contains(holidays, start) or List.Contains({5, 6}, Date.DayOfWeek(start, Day.Monday)) ], each [count] <= days, each [ date = Date.AddDays([date], 1), count = [count] + (if [holiday] then 0 else 1), holiday = List.Contains(holidays, Date.AddDays([date], 1)) or List.Contains({5, 6}, Date.DayOfWeek(Date.AddDays([date], 1), Day.Monday)) ], each [date] ), result = List.LastN(dates, 1){0} in result
jcamilo1985 I am afraid I can't comment on this. Probably because my function uses recursive call. I don't know. It's quite easy to reproduce this function using List.Generate. I'll try to do that a bit later, mate.
Thank you very much for your commitment and interest in this topic AlienSx .
After several attempts, I was finally able to find the solution, but all thanks to the base that you gave me.
Here I share it in case someone else needs it at some point.
In the same way thanks to the other people who read the thread and were interested.
(start as date, days as number, holidays as list) as date =>
let
dates = List.Generate(
() => [
date = start,
count = 1,
holiday = List.Contains(holidays, start)
or List.Contains({5, 6}, Date.DayOfWeek(start, Day.Monday))
],
each [count] <= days,
each [
date = Date.AddDays([date], 1),
count = [count] + (if [holiday] then 0 else 1),
holiday = List.Contains(holidays, Date.AddDays([date], 1))
or List.Contains({5, 6}, Date.DayOfWeek(Date.AddDays([date], 1), Day.Monday))
],
each [date]
),
result = List.LastN(dates, 1){0}
in
result
- AgataJ1 year agoHelper II
Hi jcamilo1985 , thanks for sharing the working solution, this is exactly what I needed today!