Which quarter?

Intermediate← PreviousSkip →
Exercise 11 of 11 Premium

Which quarter did order SO-1007 ship in? Return it like "Q1".

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 →