Thread: #NAME?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Windy Windy is offline
external usenet poster
 
Posts: 19
Default #NAME?

I have a spreadsheet which has the formula =NETWORKDAYS(B2,D2)-1 and now when
I try to fill information into the row the column with the formula (which
displayed -1 until this point) now fills in with #NAME? and if I move my
cusor to the above rows that had been correct, they too will change from a
numerical value to #NAME?. If I open a new workbook and try this formula I
now get #NAME? as well as on several different workstations that I have tried
it on.
What can I do to correct this situation before I fall too far behind on my
work?