Add days to get a due date
PremiumIn C2, work out the due date of the invoice. Add the payment terms in B2 to the invoice date in A2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice date | Terms (days) | Due date | |||
| 2 | Mar 15, 2024 | 30 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock Dates and DATE and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:EDATE and EOMONTHNETWORKDAYS, WORKDAY and WEEKDAY
It comes up in this mock test: Excel test for finance jobs
Need help?
Why this works
A date plus a number is a date that many days later. Mar 15, 2024 plus 30 days is Apr 14, 2024. The cell is formatted as a date, so it shows the date rather than the number 45396.
Common mistake: Adding a month by adding 30 days. 30 days is not always a month; use EDATE when the terms are in months.
The answer
- C2
=A2+B2