| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtracting networkdays
I would like to subtract and add (in two different columns), 2 WORK DAYS from
a given date. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtracting networkdays
=WORKDAY(A2,2,Holidays)
=WORKDAY(A2,-2,Holidays) look it up in help -- Regards, Peo Sjoblom "Steve" wrote in message ... I would like to subtract and add (in two different columns), 2 WORK DAYS from a given date. Does anyone know how to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtracting networkdays
Thanks for the info, but I keep getting an error message #name? Any thoughts?
"Peo Sjoblom" wrote: =WORKDAY(A2,2,Holidays) =WORKDAY(A2,-2,Holidays) look it up in help -- Regards, Peo Sjoblom "Steve" wrote in message ... I would like to subtract and add (in two different columns), 2 WORK DAYS from a given date. Does anyone know how to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtracting networkdays
On Tue, 11 Nov 2008 04:31:02 -0800, Steve
wrote: Thanks for the info, but I keep getting an error message #name? Any thoughts? You don't have the ATP installed. If you look at HELP for the WORKDAY function, you will see that error listed and also how to fix it. --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtracting networkdays
Any other suggestions? I do have the toolpac loaded and installed....I redid
it, but nothing.. "Ron Rosenfeld" wrote: On Tue, 11 Nov 2008 04:31:02 -0800, Steve wrote: Thanks for the info, but I keep getting an error message #name? Any thoughts? You don't have the ATP installed. If you look at HELP for the WORKDAY function, you will see that error listed and also how to fix it. --ron |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
subtracting networkdays
IT HAS BEEN FIXED! THANKS EVERYONE!
"Steve" wrote: Any other suggestions? I do have the toolpac loaded and installed....I redid it, but nothing.. "Ron Rosenfeld" wrote: On Tue, 11 Nov 2008 04:31:02 -0800, Steve wrote: Thanks for the info, but I keep getting an error message #name? Any thoughts? You don't have the ATP installed. If you look at HELP for the WORKDAY function, you will see that error listed and also how to fix it. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS | Excel Worksheet Functions | |||
| #NAME when using NETWORKDAYS | Excel Discussion (Misc queries) | |||
| networkdays | Excel Worksheet Functions | |||
| NETWORKDAYS Help | Excel Worksheet Functions | |||
| Networkdays | Excel Worksheet Functions | |||
Linear Mode
