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...
Need Help
  • Fowmy's avatar
    Fowmy
    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

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your post this is working for me. I have one mre concern if i need to add multiple work days based on the condition then how to add it.

 

Thanks in advance!!