Calculating days between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there anyway that I can calculate the number of days (based on a Mon-Fri
5 day working week) between two dates that are in the format: 01/01/2007 to
05/02/2007 for example?

Is there a specific function that can do this?

Any help or advice would be greatly appreciated.

Regards,

Simon.
 
Use the NETWORKDAYS function to determine the number of working days between
2 dates. You can also create a table of company holidays so that they are
excluded from the count.

If you get a #NAME error, click TOOLS in the menu and select ADD INS. In
the list of add-ins click ANALYSIS TOOLPACK and you'll be good to go...
 
Back
Top