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!