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

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Is this problem solved?

 

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If not, please let me know.

 

 

Best Regards,

Icey