calculate weekdays between two dates (MS Excel 2000)

Topic

New Reply

I have two dates in a spread sheet and I am trying to calculate the number of days between the two days, but excluding weekend days. Any ideas on how to pull that off?

Tom

Reply | Quote

Replies

In Excel 97, there’s a function called NETWORKDAYS. It may be part of the Analysis ToolPak. I’m not sure if it’s different in Excel 2000, but if you go to ToolsAdd-Ins, you might see a check box for the ‘Analysis ToolPak’.

Reply | Quote

In Excel 97, there’s a function called NETWORKDAYS. It may be part of the Analysis ToolPak. I’m not sure if it’s different in Excel 2000, but if you go to ToolsAdd-Ins, you might see a check box for the ‘Analysis ToolPak’.

Reply | Quote

As Chipshot says the correct command is NETWORKDAYS but it is a regular Excel command in 2000.

NETWORKDAYS(start_date,end_date,holidays)

NETWORKDAYS(“10/01/1999″,”2/15/2000”,{“12/24/1999″,”1/3/2000”}) excludes Dec 24, 1999 and Jan 3, 2000 and equals 96.

Go to your Excel help page and type in NETWORKDAYS for more details.

Reply | Quote

As Chipshot says the correct command is NETWORKDAYS but it is a regular Excel command in 2000.

NETWORKDAYS(start_date,end_date,holidays)

NETWORKDAYS(“10/01/1999″,”2/15/2000”,{“12/24/1999″,”1/3/2000”}) excludes Dec 24, 1999 and Jan 3, 2000 and equals 96.

Go to your Excel help page and type in NETWORKDAYS for more details.

Reply | Quote