Networkday function calculation error (at least it seems to me)

Question

Hi,

I'm trying to calculate net work day between two date without considering any weekend or holiday using NETWORKDAYS function. The formula looks like this =NETWORKDAYS(DATE(2016,8,13),DATE(2016,8,13)) which returns 0 workday where it suppose to return 1. The NETWORKDAYS.INTL version of this formula also returns 0. So far I've found this occurs for the following start and end date, DATE(2016,8,13), DATE(2016,8,14), and DATE(2017,8,13). This formula returns 1 for the following date =NETWORKDAYS(DATE(2018,8,13),DATE(2018,8,13)). Not sure what I'm missing here but any guidance will be deeply appreciated.

Answer 1

If you have you holiday dates in a range named Holidays, a start date in A1 and an end date in A2

=A2-A1+1-COUNTIFS(Holidays,">="&A1,Holidays,"<="&A2)

Answer 2

Thank you very much for your reply. I'm tying not to considering any weekend but holidays are ok. How do I accomplish that? The formula I've posted is just a skeleton one. In reality I wouldn't know which date will be Saturdays and Sundays.

Answer 3

Thank you for your reply. I understand the condition and that's why I'm tying not to considering any weekend.

Answer 4

Hi.

If the date in question is a weekend (or holiday) date, then obviously 0 will be returned; otherwise 1 will be returned.

Regards

Answer 5

NETWORKDAYS treats Saturdays and Sundays as non-working days.

The dates you are using to get 0 are Saturday or Sunday.

If you just want the number of days inclusive between two dates A1 and A2

=A2-A1+1