Add days to get a due date

Premium

In C2, work out the due date of the invoice. Add the payment terms in B2 to the invoice date in A2.

C2
ABCDEF
1Invoice date Terms (days) Due date
2Mar 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

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?