Thread: #NAME? Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MP MP is offline
external usenet poster
 
Posts: 39
Default #NAME? Error

I have a spreadsheet that I sent to a collegeau who is having difficulty with
one of the formulas. The formula is returning the #NAME? error in the cell.
However when she sent the spreadsheet to me the formula works correctly.
Here's the formula:
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(J1),1),DATE( YEAR(TODAY()),MONTH(J1)+1,0))-J10-J11-J12

The formula is used to determine the number of available shipping days in a
month minus planned shutdown days, etc.

Why does the formula work on one computer and not the other???