How To Calculate Difference Between Two Dates in Excel (DATEDIF)???

How To Calculate Difference Between Two Dates in Excel (DATEDIF)???

MS Excel DATEDIF function returns the difference between two date values, based on the given interval.

The DATEDIF function is a hidden built-in function in Excel that is categorized as a Date/Time Function. It can be used as other worksheet function of Excel, but user can’t get help of this function due to its hidden characteristics.

NoteDATEDIF is not a standard function and hence not a part of Excel functions library and so there is no documentation(help) for this. Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate wrong results under certain scenarios.


Following is syntax of  the DATEDIF function:

DATEDIF( start_date, end_date, interval )


start_date and end_date- The two dates to calculate the difference between where the start_date can’t be greater than end_date. The Entered Date format should also match with your computer Date format,i.e. if your computer Date format is MM/DD/YYYY then you can’t type DD/MM/YYYY

Interval- The interval of time to use to calculate the difference between date1 and date2 is known as INTERVAL here. Below is a list of valid interval that can be used


Interval Description
Y The number of complete years.
M The number of complete months.
D The number of days.
MD The difference between the days (months and years are ignored).
YM The difference between the months (days and years are ignored).
YD The difference between the days (years and dates are ignored).

The DATEDIF function returns a numeric value as a result.

Applies to version

  • Excel 2000 onward

Example (as a Function)
Let’s see some Excel DATEDIF function examples and learn how to use the DATEDIF function in Microsoft Excel:

Based on the above Excel spreadsheet, the following DATEDIF examples will return:


Result: 16(difference as total number of YEARS)

Note- here TODAY() is used as an end date in function argument. It is Excel inbuilt function which returns system date, i.e. current date.



Result: 191(difference as total number of MONTHS)



Result: 5828(difference as total number of DAYS)



Result: 11(difference as total number of remaining MONTHS after YEARS)



Result: 15(difference as total number of remaining DAYS after YEARS)



Result: 349(difference as total number of remaining DAYS after years)


Above picture shows how to calculate the differences between two DATES and to calculate Total using & operator. It’s nothing but substitute of Excel CONCATENATE Function.



This Post Has 9 Comments

  1. Julio

    I am genuinely thankful to the holder of this website who has shared this great paragraph at
    at this place.

  2. Jasper

    Having read this I thought it was rather informative. I appreciate you finding the time and energy to put
    this short article together. I once again find
    myself personally spending a lot of time both reading and leaving comments.
    But so what, it was still worthwhile!

  3. Brook

    Aw, this was a very nice post. Spending some time and actual
    effort to generate a very good article… but what can I say… I put things off a lot and never seem to get
    anything done.

  4. Curt

    If you are going for best contents like I do, only go
    to see this web site everyday as it provides feature contents, thanks

  5. Tommy

    Hi to all, how is the whole thing, I think every one is getting more from this site, and your views are pleasant for new people.

  6. Ronda

    Remarkable issues here. I am very glad to look your article.

    Thank you a lot and I’m taking a look ahead to touch you.
    Will you kindly drop me a mail?

  7. Nila

    WOW just what I was looking for. Came here by searching for website

  8. Rosalina

    Pretty nice post. I just stumbled upon your blog and wanted to say that I’ve
    truly enjoyed surfing around your blog posts. In any case I
    will be subscribing to your feed and I hope you
    write again very soon!

  9. Fermin

    It’s going to be end of mine day, however before ending I am reading
    this impressive piece of writing to improve my knowledge.

Leave a Reply