Excel date functions practice: EOMONTH, NETWORKDAYS and TEXT

Lesson 7 · Pro

fx

The 7 exercises in this lesson

  1. The studio groups invoices by month. In F5, return the month number (1 to 12) of INV-1044's issue date, C5.
  2. How long did Pine Street Books take to pay INV-1045? In F6, return the number of days from the issue date (C6) to the payment date (D6).
  3. The studio's terms: an invoice is due on the last day of the month it was issued. In F4, return the due date of INV-1043, issued on 2/20/2025 (C4).
  4. Same invoice as drill 2, counted the way the studio's bookkeeper does: business days only. In F6, count the working days from C6 to D6, skipping weekends and the holidays listed in H2:H7.
  5. The monthly report labels each invoice by month, like Jan 2025. In F5, turn INV-1044's issue date (C5) into that label with TEXT.
  6. A payment reminder needs the line Amount due: $2,180.50. In F6, build it for INV-1045: the text "Amount due: " joined with & to the amount in E6, formatted with TEXT.
  7. Last one. Terms are net 30 end of month: due 30 days after the end of the month the invoice was issued. INV-1047 hasn't been paid. In F8, show "Overdue" if its due date is before today (G2), otherwise "OK". (In a real file G2 would be =TODAY(); here it's fixed so the answer doesn't change.)

More Excel practice

Excel practice onlineExcel skills testExcel formula playgroundExcel practice for beginnersExcel IF function practiceVLOOKUP practice exercisesXLOOKUP practice exercisesSUMIFS and COUNTIFS practiceINDEX MATCH practice exercisesExcel keyboard shortcuts practicePivot table practice exercisesSQL practice onlineLearn to read financial statements