Calculate no of days between two dates in excel

An 'Excel in Minutes' Tip. The " ym " interval code yields the number of months between the two dates as if they were in the same year and ignores the year.

Count Days Between Two Dates in Excel

The " yd ", and " md " interval codes yields the number of days between the two dates as if they were in the same year and ignores the year. Facebook Twitter Print Email Pinterest Gmail More. Would you believe me if I told you that you can DOUBLE your productivity in Excel?

How about TRIPLE it? Enter Your Name Enter Your Primary Email.

Calculating the number of days using Excel is pretty simple. Just use a formula to subtract the later date from the earlier date.

If the result you get looks like a weird date rather than a number of days, that's because Excel assumed you were entering another date and automatically formatted cell A3 as a date. To fix that, from the Home tab click the Number Formats dropdown in the Number group and select General. Your answer should be However, calculating the number of months or years between two dates isn't so obvious.

Calculate the difference between two dates - Excel

There's a Function in Excel that makes this task easy but for some reason Microsoft has hidden it away. This 'secret' function is called DATEDIF i.

Let's use the same dates as above. The syntax for the function is Change cell A1 to a date a year or more earlier and you'll see the result.

How to Calculate Number of Days Between Two Dates in Excel

A few of things to keep in mind about the DATEDIF function: To calculate the number of years, months and days between two dates more than a year apart you can use this formula assuming your start date is in cell A1 and your end date is in cell A2.

Rather than attempting to retype this formula below, simply highlight and copy it from here, paste into your formula bar and then adjust the cell references as necessary.

Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.