| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
cal number of days
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 |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
cal number of days
Hi
try =NETWORKDAYS(TODAY(),A1) -- Regards Frank Kabel Frankfurt, Germany greg wrote: 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 |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
cal number of days
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 "Frank Kabel" wrote in message ... Hi try =NETWORKDAYS(TODAY(),A1) -- Regards Frank Kabel Frankfurt, Germany greg wrote: 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 |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
cal number of days
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 "greg" wrote in message ... 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 "Frank Kabel" wrote in message ... Hi try =NETWORKDAYS(TODAY(),A1) -- Regards Frank Kabel Frankfurt, Germany greg wrote: 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 |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
cal number of days
NETWORKDAYS requires the Analysis Toolpak (ATP) be
installed and activated in Excel Check the "Analysis Toolpak" box (via Tools Add-Ins) Chip Pearson's page has details on the ATP at: http://www.cpearson.com/excel/ATP.htm -- Rgds Max xl 97 -- Please respond, in newsgroup xdemechanik <atyahoo<dotcom --- "greg" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
cal number of days
SWEET!
thanks all! "JulieD" wrote in message ... 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 "greg" wrote in message ... 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 "Frank Kabel" wrote in message ... Hi try =NETWORKDAYS(TODAY(),A1) -- Regards Frank Kabel Frankfurt, Germany greg wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find number of weekdays and wekend days given a total number of da | Excel Discussion (Misc queries) | |||
| Convert Number of Month to Number of days | Excel Discussion (Misc queries) | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
| A number of days into weeks and days | Excel Worksheet Functions | |||
Linear Mode
