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
A2from dateB2to 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.