date format
 

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.

date format
 

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
HIS


"Tiffany" wrote in message
...
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.

date format
 

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

date format
 

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

"Nick Hodge" wrote:

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
HIS


"Tiffany" wrote in message
...
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.