Calculate the difference between two dates, exempting the weekends and holidays, using =NETWORKDAYS
Using NETWORKDAYS function:
- Format: =NETWORKDAYS ( date1, date2, holidays)
- date1 must be the earlier of the two dates.
- holidays is an optional argument
Cheers!
hɔuᴉnb
Additional reading:
- Hidden Excel function for calculating Date Differences
- J.K. Rowling made more $ than Drake and Cristiano Ronaldo this year
- Excel Data Consolidation
- More Excel Tips
Comments questions (and magik tricks) are always welcome!
Ask Quincy 