View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suzanne Suzanne is offline
external usenet poster
 
Posts: 152
Default #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?