Return count of working days between two dates

[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

[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)

[YasserKhalil]

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