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.
It comes up in this mock test: Excel test for finance jobs
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
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