Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
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...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

    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.

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

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.

 

CD_75's avatar
CD_75
Frequent Visitor
2 years ago

Thank you - this was exectly what I was looking for.