Number of weekdays between 2 dates

[certain_death]

Hey all

Can anyone help me in writing a formula that tells me the amount of weekdays (not incl Sat and Sun) between 2 dates.

Have just updated from Excel 2000 to Excel 2003, in Excel 2000 I used to use a formula called NETWORKDAYS but doesnt seem to exist in Excel 2003

Can anyone help me please

Thanks

[Richard Schollar]

Hi

To use NETWORKDAYS (in both xl2000 and xl2003) you need to ensure that the Analysis Toolpak add-in is installed - you do this via Tools>Add-Ins and make sure it is checked. Then you can use the formula in your spreadsheet exactly as you did in xl2000.

Richard

[dominicb]

Good morning certain_death

in Excel 2000 I used to use a formula called NETWORKDAYS but doesnt seem to exist in Excel 2003

The NetworkDays function isn't actually a part of Excel, it is contained within the Analysis Toolpak add-in. To invoke it just go to Tools > Addins and select Analysis Toolpak from the list.

HTH

DominicB

[certain_death]

Ah i see

Cheers guys, my add in wasnt installed.

Just done it works fine...cheers guys thats brilliant

Regards
CD