ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   My Datedif function only returns 0's in the cell what's wrong? (https://www.excelbanter.com/excel-worksheet-functions/83134-my-datedif-function-only-returns-0s-cell-whats-wrong.html)

Tom

My Datedif function only returns 0's in the cell what's wrong?
 
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.

Peo Sjoblom

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.





All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com