TODAY and how to work out a due date
Add the days of credit to an invoice date to get the due date. Then use TODAY to see how late a payment is.
Task 1Working out a due date4 questions
A due date is the invoice date plus the days of credit. Adding a number to a date moves it on by that many days.
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Invoice date | Days of credit |
| 2 | 2151 | 2 February 2026 | 30 |
| 3 | 2152 | 16 February 2026 | 14 |
| 4 | 2153 | 27 February 2026 | 30 |
=B2+C2 gives the due date of the invoice in row 2. Format the answer as a date.
Some terms run by the month. =EDATE(B2,1) is the same day one month later, =EOMONTH(B2,0) is the last day of the invoice month, and =EOMONTH(B2,1) is the last day of the month after.
Task 2TODAY and days overdue4 questions