Hi Fred,

Just test with today (Jul 3 2005) and Dec 5 2004

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Fred Smith" wrote in message
...
=(DAY(A1)-DAY(A2))&" days and "&(MONTH(A1)-MONTH(A2))&" months"

will get you the answer you are looking for.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"kasey" wrote in message
...
Thank you for your quick response. I unfortunately have tried that and
it
doesn't work either. I even have some calculations that are within the
same
day and the month will show up as 1, the day shows up as 0 (which is
should),
and the time calculation is correct. Thank you for your help!

"Andy" wrote:

Hi

Try formatting the result as General. This will give you 60 days. I
don't
know how the answer can be '29 and one month'!

Andy.

"kasey" wrote in message
...
please help me in something
i have two cells:
31/10/2004 18:00
01/09/2004 07:00
i want to subtract the two cells
the result i am taking is 29/02/1900 11:00
but the correct result is 29 and one month
what can i do
thanks