View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default #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?