• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count dates excluding weekends by formula

nagovind

Member
Dear All,
Total working days in a week 5 days (Friday and Sat weekly off)
Task1 starts at 06 09 2020---(1)
Task1 needs 10 days of work
Task1 ends at 17 09 2020---(2)
How to get (1) + 10 = (2) excluding the dates 11 and 12

How to automate this to find the next date excluding Frid and Saturday after the specified number of worked days
70668
Regards
Narayan Govind
 
@nagovind

=WORKDAY.INTL(Date - 1,10, 7)

-1 is needed here, as WORKDAY calculation is exclusive, but your logic/calculation is inclusive.
Meaning WORKDAY starts counting workday after the start date. But you start count from start date.

Also, WORKDAY.INTL is required here as you are not using standard weekend (Sat & Sun). Option 7 is for Fri & Sat weekend.
 
Back
Top