Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Add working days to a Date

Hi, I have a date and I have to add to it 15 working days (excluding Weekends) Now I am using this in power query:   Date.AddDays([Date],15)  which is adding 15 days but including weekends.   An...
  • Fowmy's avatar
    6 years ago

    Anonymous 

    Check the attached file. Provide Start Date and Work Days to Add, It will add workdays. currently, it excluded SAT and SUN.

    You can download the file: HERE

     

     

     

    ______________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn