Ask Experts Questions for FREE Help !
Ask
    shazydotcom's Avatar
    shazydotcom Posts: 23, Reputation: 1
    New Member
    		  
    #1

    Dec 22, 2009, 12:21 AM
    Display difference of two days as year, month and days
    My question is that if it is possible that we can display the difference of two dates as Years, Months and days. For example

    A B C
    1 6/23/2002 11/30/2009 7 year 5 month 11 days

    The actual difference between dates in B1 and A1 is 7 Years, 5 Months and 11 days. Normally we see that we can calculate difference in terms of years, or months or days. But I don't know if excel provides a function which can display the result as completely as I showed in C1.

    If anyone knows, please help.

    Thanks in advance.
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
    		  
    #2

    Dec 22, 2009, 04:32 AM

    This is the closest I can get it :-


    A B C
    1 6/23/2002 11/30/2009 7 year 5 month 11 days

    B A C
    9,11,30 2,06,23 7,5,7

    ##################################################

    MY AGE TO-DAY
    B A C
    2009,12,22 1930,10,02 79,2,20
    ##################################################

    What I am saying is that you do not need anything special to get this.
    Express the date in YEAR, MONTH and DAYS and then subtract on sight.
    I believe this would be accurate enough.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Dec 22, 2009, 10:02 AM

    Try this in C1:

    =DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, "&((B1-A1)-(DATEDIF(A1,B1,"y")*365))-((DATEDIF(A1,B1,"ym"))*30) & " days"

    Code:
    6/23/2002	11/30/2009	7 years, 5 months, 12 days
1/1/2007	7/15/2009	2 years, 6 months, 16 days
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Is a 30 days notice sufficient if my lease has ended and I know pay month to month? [ 4 Answers ]

So I signed a rental agreement for a 6 month lease effective January-June and have fulfilled the terms but my lease expired on June 30, 2008. My landlord asked if I would like to renew the lease and I said sure but she has not drawn up the paperwork to renew the lease for another 6 months. In...

Month-to-Month leasing, eviction notice days. [ 11 Answers ]

Ok... we signed a written lease, that is month to month, on a Mother-in-Law suite. We agreed to pay a first and last. The landlord is terminating our lease, and has claimed that the law is to give 15 days to vacate the premises NOT 30. Is this legal? Or will he have to return our deposit? How does...

How can I ask my roommate to give 30 days notice on a month to month lease ? [ 1 Answers ]

I am3 months into a month to month agreement with my current roommate. We were in a 6 month lease together that has expired over 3 months ago. I am currently wanting to dissolve the relationship and go into a 12 month lease with our landlord on my own. I know she is not ready to vacate, but can I...

Breaking a month to month lease that was signed 2 days ago. [ 1 Answers ]

Would I Be Able To Collect Back Money Paid To A Lessor For Security Deposit And 1st Months Rent If Apartment Is Not In A Sanitary And Safe Condition And the Lease Was Signed 2 Days Ago And Never Moved Into The Apartment And The Lease Is Month To Month

View more questions Search