Formula - Excluding weekends & holidays
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
|