# I need to find out the YEAR, MONTH, DAY between two dates

1. ## I need to find out the YEAR, MONTH, DAY between two dates

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.

Thanks

2. ## Re: I need to find out the YEAR, MONTH, DAY between two dates

=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" <jimmy@discussions.microsoft.com> 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

3. ## RE: I need to find out the YEAR, MONTH, DAY between two dates

=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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1