Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom
 
Posts: n/a
Default 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.
  #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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function that Returns address of that cell? RayWolfDog Excel Worksheet Functions 2 February 15th 06 05:54 PM
month worksheet function returns wrong value Barry Excel Worksheet Functions 6 January 28th 06 01:37 AM
When using MONTH function on Blank Cell!! Returns Month=Jan! mahou Excel Discussion (Misc queries) 6 January 9th 06 03:46 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 04:31 AM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"