Why can I not find "DATEDIF" in the function
reference in the help file?
Read the first paragraph on this page:
http://www.cpearson.com/Excel/datedif.aspx
--
Biff
Microsoft Excel MVP
"Lil Red Riding In The Hood"
<lilredridinginthehood@grandmashouseattheendoftheu niverse.org wrote in
message ...
Why can I not find "DATEDIF" in the function reference in the help file?
On Sun, 21 Feb 2010 13:38:55 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:
Do they have any intention of fixing it?
On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur"
wrote:
Hi,
There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer
=DATEDIF($A13,$B13,"md")
I work around it by using =B13-EDATE(A13,(C13*12)+D13)
C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")
Hope this helps.