Days to ship

IntermediateSkip →
Exercise 1 of 11

How many days did order SO-1002 take to ship?

Write your formula in the green cell, G2.

Dates & times

Days to shipWhich month?Day of the weekInvoice due dateAdd monthsWorking daysCalculate inside MAXTotal for one monthCount dates in a monthWhole months between datesWhich quarter?
shipping-log.xlsx
fx
1Order IDOrder dateShip dateAmount
2SO-1001Jan 5, 2026Jan 8, 2026$420.00Days
3SO-1002Jan 12, 2026Jan 20, 2026$1,180.00
4SO-1003Jan 27, 2026Feb 2, 2026$760.00
5SO-1004Feb 9, 2026Feb 10, 2026$2,350.00
6SO-1005Feb 16, 2026Feb 26, 2026$515.00
7SO-1006Mar 2, 2026Mar 5, 2026$1,990.00
8SO-1007Mar 23, 2026Apr 1, 2026$880.00
9
10

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

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 →