Excel Hack 31: Calculate the number of working days between dates
This task is powered by the =NETWORKDAYS() Excel function, and can come in handy when creating project work plans or Gantt charts. The syntax is below: =NETWORKDAYS(start-date, end-date, [number of holidays] ) If the national or public holidays for the duration of the project are known, these can be entered into excel as a list,