If I modify the formula slightly, I get the answer I need:
=NETWORKDAYS(K42,N42,NonWorkDays)-1 I am taking one day off because I don't
want to include the departure day, which is the first date, which is the same
answer N42-K42 will give me. Thank you very much!


"Roger Govier" wrote:

Hi Connie

So what result does it give you if you enter
=NETWORKDAYS(K42,N42,Non Work Days)



--
Regards
Roger Govier
"Connie Martin" wrote in message
...
I have this very simple formula: =N42-K42 Both N42 and K42 are dates.

QUESTION #1
Is there a way to incorporate into this formula something that would
exclude
weekends when it calculates the number of days' difference?

QUESTION #2
Is there also a way to incorporate into this formula something that would
exclude statutory holidays when it calulcates the difference? I assume I
would need to put a list of statutory holidays somewhere in the worksheet
or
on another worksheet.

Thank you
Connie Martin