date format

[Tiffany]

Hi

I have a question and hope someone can help.

I have 2 dates

e.g. 11/1/2005 (mm/dd/yyyy) and 9/1/2005 (mm/dd/yyyy). If I substract them,
I will get 61 days. However, i do not want to show 61 days, i want to show 2
months instead.

e.g. 11/1/2005 - 9/25/2004 = ? months and ? days


can anyone help.

 

[Nick Hodge]

Tiffany

Something like

=DATEDIF(A2,A1,"m")&" months "&DATEDIF(A2,A1,"md")&" Days"

DATEDIF is not in help (Except 2000) it was put in for compatibility with
Lotus 1-2-3, you can find help here

http://www.cpearson.com/excel/datedif.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[sajay64]

wrong posting?? yeh!!
no questions but only answers

 

[Tiffany]

Nick, thank you very much. This is exactly what I want.