Return count of working days between two dates

YasserKhalil
PlatinumLounger
Posts: 4685
Joined: 31 Aug 2016, 09:02

Return count of working days between two dates

Post by YasserKhalil »

Hello everyone
I have a problem with the following formua

Code: Select all

=NETWORKDAYS(AJ1,AJ2,$AA$1:$AA$13)
AJ1 has the date 01/10/2021 (first day in October)
AJ2 has the date 31/10/2021 (last day in October)

The holidays are listed for October in AA1:AA6
2021/10/03
2021/10/04
2021/10/05
2021/10/06
2021/10/07
2021/10/21

The count of working days is supposed to be 15 but I got 16. Of course, Friday and Saturday are holidays too

User avatar
HansV
Administrator
Posts: 74177
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Return count of working days between two dates

Post by HansV »

NETWORKDAYS uses Saturday and Sunday as weekend days. To use Friday and Saturday as weekend days, you need NETWORKDAYS.INTL:

=NETWORKDAYS.INTL(AJ1,AJ2,7,AA1:AA6)
Regards,
Hans

YasserKhalil
PlatinumLounger
Posts: 4685
Joined: 31 Aug 2016, 09:02

Re: Return count of working days between two dates

Post by YasserKhalil »

Thank you very much, my tutor. That worked very well.