Tools / Dates and deadlines

Days between dates

For notice periods, contract terms and how long an invoice has been open.

Days
305
Weeks and days
43 weeks, 4 days
Whole months
10

Do it in a spreadsheet

=B2-A2
  • A2 from date
  • B2 to date

How it works

Subtracting one date from another gives the days between them, not counting the first day. For whole months use =DATEDIF(A2,B2,"M"), which needs the earlier date first.

More dates and deadlines tools

Free, from Producfy

Get the next guide before you need it

One email when a new guide or tool goes up: working formulas, queries and scripts for spreadsheets, SQL and the CRM and billing exports that end up in them. At most one a week.

Esc