Tag: functions

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!