Need help with formula to calculate workdays

Hello,

I need help with a formula : ). I have the following formula in cell BI3:

=IF(AND(A3<>"",AN3<>""),A3-AN3,"")

where both A3 and AN3:

- are formatted as dates;
- are always workdays (Mon-Fri).

I need to know how to modify this formula so that upon subtraction of A3 and AN3 I would receive in BI3 the number of workdays between the dates A3 and AN3 instead of the number of calendar days.

Many thanks in advance!

Try using NETWORKDAYS.

Assuming that your start date is in AN3 and your end date is in A3, try this:

=IF(AND(A3<>"",AN3<>""),NETWORKDAYS(AN3,A3),"")

Thanks for the quick reply . Your assumption is correct but no, this doesn't seem to work. I set AN3 to October 18, 2017 and A3 to October 19, 2017. With my formula, I'd get "1" in BI3 and with your formula I'd get "2".

Any other suggestions?

NETWORKDAYS counts both the start and end dates as days.

Simply subtract 1 from the result. That is:

=IF(AND(A3<>"",AN3<>""),NETWORKDAYS(AN3,A3)-1,"")

You solved it falcondude And I just learnt something new Thank you very much!

You're very welcome. Thanks for the rep!

If that solved your question, please mark this thread as SOLVED.

How do I set this to thread to SOLVED falcondude?

To mark a thread as SOLVED, select Thread Tools from the menu link above and mark this thread as SOLVED.