Thread
:
#NAME? Some users get error some don't?
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
#NAME? Some users get error some don't?
Holly mollie. Glad to help
--
Don Guillett
SalesAid Software
"Suzanne" wrote in message
...
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett