Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Some users get error some don't?
I have a very simple date calculation in a spreadsheet.
=IF(OR(F27="",G27=""),"",NETWORKDAYS(F27,G27,$AJ$1 2:$AJ$19)) When some users key dates into F27 and G27 the days calculates Others get the #NAME? error. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Some users get error some don't?
From the help index
NETWORKDAYS See Also Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. -- Don Guillett SalesAid Software "Suzanne" wrote in message ... I have a very simple date calculation in a spreadsheet. =IF(OR(F27="",G27=""),"",NETWORKDAYS(F27,G27,$AJ$1 2:$AJ$19)) When some users key dates into F27 and G27 the days calculates Others get the #NAME? error. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#NAME? Some users get error some don't?
Good grief! Thank you very much.
"Don Guillett" wrote: From the help index NETWORKDAYS See Also Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. -- Don Guillett SalesAid Software "Suzanne" wrote in message ... I have a very simple date calculation in a spreadsheet. =IF(OR(F27="",G27=""),"",NETWORKDAYS(F27,G27,$AJ$1 2:$AJ$19)) When some users key dates into F27 and G27 the days calculates Others get the #NAME? error. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"File Is Locked" Error Message (not by other users) | Excel Discussion (Misc queries) | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
Why are german users getting an error with Mround? ATP installed. | Excel Worksheet Functions | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |