+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    jimmy
    Guest

    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.

    Please send me the formula.

    Thanks

  2. #2
    Bob Phillips
    Guest

    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
    news:781B4F2A-A6E4-48AD-B6DA-9885095786A8@microsoft.com...
    > 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. #3
    Marcelo
    Guest

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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