Hi Jv,

take a look at DATADIF function help.

=DATADIF(INITIALDATE,FINALDATE,"X")

X could be:

D = days between both dates
M = Months between both dates
Y = Years between both dates
MD = difference between both dates but, months and years are ignorated
YD = difference between both dates but, days and years are ignorated

hth
regards from Brazil
Marcelo

"Jv." escreveu:

Hi
I need to count time in days/montht/years from one period to another.
I have tried to do a simple calkulation like 15-01-2001 minus 01-01-2000,
but problem is, that excell does not have a zero month and with some
calkulations makes plus one month. It also makes some mistakes in
calkulations of days...
Does somebody knows how to solve it?

Thank you :-)