View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default My Datedif function only returns 0's in the cell what's wrong?

Toolsoptionstransition uncheck "transition formula evaluation"


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Tom" wrote in message
...
My =Datedif("1999/12/1","2005/12/1","Y") function only returns 0's in the
cell what could be the problem?
Cell is formatted for numbers.