Add months

Intermediate← PreviousSkip →
Exercise 5 of 11 Premium

Order SO-1002 has a 3-month warranty that starts on its ship date. When does it end?

Checking your plan…

shipping-log.xlsx

ABCD
1Order IDOrder dateShip dateAmount
2
3
4
5
6
7
8

About dates & times in Excel

Excel stores dates as numbers, which is why you can subtract them. Practice working out shipping times, due dates, working days and monthly totals from a real shipping log.

Functions you can use here

  • MONTH(serial_number)
  • EOMONTH(start_date, months)
  • NETWORKDAYS(start_date, end_date, [holidays])
  • DATE(year, month, day)

More dates & times exercises

  1. 1.Days to ship
  2. 2.Which month?
  3. 3.Day of the weekPremium
  4. 4.Invoice due datePremium
  5. 5.Add monthsPremium
  6. 6.Working daysPremium
  7. 7.Calculate inside MAXPremium
  8. 8.Total for one monthPremium
  9. 9.Count dates in a monthPremium
  10. 10.Whole months between datesPremium
  11. 11.Which quarter?Premium
See the whole topic →