Tools>options>transition uncheck "transition formula evaluation"


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Tom" <Tom@discussions.microsoft.com> wrote in message
news:523D30E8-B299-404D-A47F-C7CAE33D399A@microsoft.com...
> 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.