I need to find out the YEAR, MONTH, DAY between two dates. for example:
A1:19/05/05 and A2: 30/06/06. How can I have to difference in year, month,
day.
If 0 year, automatically the result must be run out in month, day and so on.

Please send me the formula.

Thanks

=DATEDIF(A1,A2,"Y")

=DATEDIF(A1,A2,"YM")

=DATEDIF(A1,A2,"MD")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jimmy" wrote in message
...
I need to find out the YEAR, MONTH, DAY between two dates. for example:
A1:19/05/05 and A2: 30/06/06. How can I have to difference in year, month,
day.
If 0 year, automatically the result must be run out in month, day and so
on.

Please send me the formula.

Thanks

=datedif(a1,a2,"y")& "years, "&datedif(a1,a2,"ym")&"months,
"&datedif(a1,a2,"md")&" days."

hth
regards from Brazil
Marcelo

"jimmy" escreveu:

I need to find out the YEAR, MONTH, DAY between two dates. for example:
A1:19/05/05 and A2: 30/06/06. How can I have to difference in year, month,
day.
If 0 year, automatically the result must be run out in month, day and so on.

Please send me the formula.

Thanks