#NAME? Some users get error some don't?

S

Suzanne

I have a very simple date calculation in a spreadsheet.
=IF(OR(F27="",G27=""),"",NETWORKDAYS(F27,G27,$AJ$12:$AJ$19))
When some users key dates into F27 and G27 the days calculates
Others get the #NAME? error.
Any ideas?
 
D

Don Guillett

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.
 
S

Suzanne

Good grief! Thank you very much.

Don Guillett said:
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.
Click to expand...
 
Top