Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS
I have a formula that is working fine for calculating the time between dates:
=IF((O3<"")*(N3<""),(O3-N3),"") I need to change it to business days between dates. I tried: =IF((O3<"")*(N3<""),NETWORKINGDAYS(O3,N3),"") The "#Name!" is returned. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS
you have networkdays in the subject and networkINGdays in the formula.
-- Gary Keramidas Excel 2003 "PAL" wrote in message ... I have a formula that is working fine for calculating the time between dates: =IF((O3<"")*(N3<""),(O3-N3),"") I need to change it to business days between dates. I tried: =IF((O3<"")*(N3<""),NETWORKINGDAYS(O3,N3),"") The "#Name!" is returned. Any ideas? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS
There is no such function as NETWORKINGDAYS
You had it right in the subject line of the post. It is NETWORKDAYS If you have problems with that, look at Excel help for NETWORKDAYS -- David Biddulph "PAL" wrote in message ... I have a formula that is working fine for calculating the time between dates: =IF((O3<"")*(N3<""),(O3-N3),"") I need to change it to business days between dates. I tried: =IF((O3<"")*(N3<""),NETWORKINGDAYS(O3,N3),"") The "#Name!" is returned. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Networkdays | Excel Discussion (Misc queries) | |||
networkdays | Excel Worksheet Functions | |||
Help on Networkdays | Excel Worksheet Functions | |||
NETWORKDAYS Help | Excel Worksheet Functions | |||
Networkdays? | Excel Discussion (Misc queries) |