Forum Discussion
Solved
Power Query - list dates forward, but excluding weekends
How do I solve the attached problem. I've been given the number of holidays requested by employees and their start request date, and would like to roll the dates forward by individual day, but ex...
Hi sachintandon84
Please see the attached solution containing two extra tables, holiday and dates.Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Hello sachintandon84
I assume you need the solution in Excel, right?
Do you have expierience with M-language? If you put a similar function that I created once here as an Idea how it could work, are you able to adapt it by your own?
Bye
Jimmy
Hi Jimmy,
Yes, am looking for an Excel solution for this.
I'm very familiar with M-Code, but couldn't work out a PQ solution for it.
Any ideas on how to do it?
Sachin