How to Calculate Days Between Two Dates
Updated
How many days until a deadline, how long a notice period runs, how many working days a project has: counting days between dates sounds easy but trips over months of different lengths, leap years and holidays. Here's how to get it right.
Days between two dates
Subtract the earlier date from the later one. From 1 April 2026 to 31 March 2027 there are 364 days between the dates. If both the first and last day count, as for a rental period or a leave application, add one: 365 days.
Watch for leap years
February has 29 days in leap years: 2024 and 2028 are leap years, 2026 and 2027 are not. Years divisible by 100 are only leap years if they're also divisible by 400, which is why 2000 was a leap year and 2100 won't be. Counting by hand is where most errors creep in.
Working days
Working days leave out weekly offs and holidays. For a Monday-to-Friday week, count the weekdays between the dates and subtract any public holidays that fall on them. Indian banks are also closed on the second and fourth Saturday of every month, as well as on Sundays.
Adding days or months
Adding days is straightforward: 45 days after 19 November 2026 is 3 January 2027. Adding months is trickier, because months have different lengths: one month after 31 January lands on the last day of February. Decide whether a deadline is a number of days or a number of months, as they rarely give the same date.
In Excel
Days between dates: =B1-A1, or =DAYS(B1, A1). Working days, Monday to Friday: =NETWORKDAYS(A1, B1, holidays), where holidays is a range of holiday dates. For other weekly offs, such as Sunday only: =NETWORKDAYS.INTL(A1, B1, 11, holidays). Adding months: =EDATE(A1, 3).
Common uses
Notice periods, loan and FD tenures, visa and passport validity, pregnancy due dates, interest for a number of days, and age on a cut-off date all come down to date arithmetic. For age in years, months and days, the Age Calculator handles the details.
Try it
The Date Calculator counts days and working days between two dates, with your own weekly off, Indian bank-holiday Saturdays and extra holidays, and adds or subtracts days, months and years.