Working days

Intermediate← PreviousSkip →
Exercise 6 of 11 Premium

How many working days (Monday to Friday) did SO-1005 take, counting both the order and ship dates?

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 →