View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lina Lina is offline
external usenet poster
 
Posts: 20
Default EDate function + #NAME? error

Hi all,

I have a user with Excel 2000 experiencing a problem with her EDATE
function. Presently, she has her formula set to EDATE(+D12(J12*12)). Her
cells are formated with a custom date format. She does have the add-in
installed. She only seems to get the #NAME? error at the beginning of a new
year. She used to have her calculations on automatic, but for now they are on
manual. Any ideas on how to fix this?

Thanks!