Count dates excluding weekends by formula

[nagovind]

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

Regards
Narayan Govind

 

[Peter Bartholomew]

The function you need is
=WORKDAY(start_date, days)

 

[abhishek4anand]

Hi,

May be below formula works to automate
=WORKDAY.INTL(EOMONTH(TODAY(),0)+6,IF(ROW(A1)-1=0,0,ROW(A1)-1),7)

 

[Chihiro]

@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.

 

[nagovind]

@Chihiro
Thank you
it is working
=WORKDAY.INTL(Date - 1,10, 7)