Calculating days between dates
 

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.

Calculating days between dates
 

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...
--
Kevin Backmann


"SiH23" wrote:

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.