#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?

#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?

#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?

#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?