Excel to calculate no of days between 2 dates?

How do i calculate the number of days between 2 dates INCLUDING the 2 dates too. E.G difference between 01/05/2012 and 31/05/2012 returns 29 when i use the days360 formula but i want it to include the 2 days and return 31.

3 Answers

  • Greg G
    Lv 7
    9 years ago
    Favorite Answer


    Try this formula:

    =IF(DATEDIF(A2, B2, "y")=0, "", DATEDIF(A2, B2, "y")&" years ")&IF(DATEDIF(A2, B2, "ym")=0, "", DATEDIF(A2, B2, "ym")&" months ")&DATEDIF(A2, B2, "md")+1&" days"

    A2 is the start date

    B2 is the end date

  • 4 years ago

    the information you would be able to desire to do it is accessible interior the help record on Excel A a million Date 2 6/8/2007 3 6/20/2007 formula Description =A3-A2 Days between the two dates (12) =NETWORKDAYS(A2,A3) Weekdays between the two dates (9)

  • IXL@XL
    Lv 7
    9 years ago

    C1 =MAX(A1,B1)-MIN(A1,B1)+1

    Date order not required using above otherwise use Later date - Early date +1

Still have questions? Get your answers by asking now.