cal number of days

G

greg

Hello,

I am wondering if excel has a function to do this:

I have created a work plan in excel.

And I have an end day. Let's say Oct 31 2004

Can I enter that in 1 cell? Then have a calculation that will give me the
number of work days (mon-fri) between the current day and that day.

I can just have another cell with the number of holidays. And just subtract
that amount.



Thanks in advance
 
G

greg

thanks for the quick reply.
I do see from the excel help that NETWORKDAYS does
Calculate the difference between two dates

however when I do
=NETWORKDAYS(TODAY(),A1)
with A1 = 10/31/2004

I get #NAME? error.

Also if I try
=NETWORKDAYS(A2,A3)
with A2 and A3 =
10/31/2004
8/4/2004

I still get the #NAME? error.

does this work in excel 2003?

Just doing =A2-A3 gives a number. but that is all of the days. not
weekdays.

any ideas?
thanks
 
J

JulieD

Hi Greg

it's one of the functions found in the Analysis Tool-Pak add-in ... to add
it choose Tools / Add-ins and tick Analysis ToolPak. Once you've done that
you'll need to click in the cell that got the formula in it and press Enter
again.

Hope this helps
Cheers
JulieD
 
G

greg

SWEET!

thanks all!



JulieD said:
Hi Greg

it's one of the functions found in the Analysis Tool-Pak add-in ... to add
it choose Tools / Add-ins and tick Analysis ToolPak. Once you've done that
you'll need to click in the cell that got the formula in it and press Enter
again.

Hope this helps
Cheers
JulieD
Click to expand...
 
J

Jason Morin

NETWORKDAYS is an additional function that is part of the
Anaylsis ToolPak. To install, go to Tools > Addins.
After installing, re-type your formula or press enter in
the formula cell.

HTH
Jason
Atlanta, GA
 
Top