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