✕
0 / 63

Excel EOMONTH and NETWORKDAYS

Invoices are due on the last day of the month after they are sent. In C2:C6, work out each due date. In D2:D6, count the working days, Monday to Friday, from the day it was sent to the due date.

EOMONTH(date, months) gives the last day of the month that many months away: 0 is the same month, 1 the next. NETWORKDAYS(start, end) counts the weekdays between two dates, both ends included.

53 Month ends and working days EOMONTH, NETWORKDAYS Advanced

invoices.xlsx
Ready

Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.

Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.

The EOMONTH, NETWORKDAYS guide

=EOMONTH(B2, 1) gives the last day of the month after the date in B2. =NETWORKDAYS(B2, C2) counts the weekdays from B2 to C2, both days included. Together they answer "when is it due, and how many working days is that?"

AdvancedAbout 3 minutesBy Updated

EOMONTH: the end of a month

=EOMONTH(start_date, months)

The second argument counts months from the start date: 0 is the end of the same month, 1 the end of next month, -1 the end of last month. An invoice sent on 1/14/2026 with terms "end of next month" is due on =EOMONTH(B2, 1), which is 2/28/2026. February, leap years and 30-day months are handled for you.

Two handy tricks: =EOMONTH(B2, -1) + 1 is the first day of B2's month, and =DAY(EOMONTH(B2, 0)) is the number of days in that month.

EDATE is not the same

=EDATE(B2, 1) moves to the same day one month later: 1/14/2026 becomes 2/14/2026. Use EDATE for "one month after", EOMONTH for "the end of the month".

NETWORKDAYS: weekdays between two dates

=NETWORKDAYS(start_date, end_date, [holidays])

It counts Monday to Friday, and includes both the start and the end date when they are weekdays. From 1/14/2026 to 2/28/2026 there are 46 calendar days but 33 working days. Plain subtraction, =C2-B2, or DAYS count weekends too.

The optional third argument is a range of holiday dates to skip as well. If your weekend isn't Saturday and Sunday, NETWORKDAYS.INTL lets you choose which days count.

If you see a number like 46081

Excel stores dates as numbers: 46081 is 2/28/2026. If a date formula shows a number, format the cell as a date. If a day count shows as a date, format it as General.

Common mistakes

FAQ

How do I get the last day of the month in Excel?
Use =EOMONTH(A1,0) for the end of A1's month, =EOMONTH(A1,1) for the end of next month and =EOMONTH(A1,-1) for the end of last month.
How do I count working days between two dates in Excel?
Use =NETWORKDAYS(start,end). It counts Monday to Friday, including both dates. Add a range of holiday dates as the third argument to skip those too.
What is the difference between EOMONTH and EDATE?
EDATE moves to the same day a number of months later. EOMONTH moves to the last day of the month that many months later.
Why does EOMONTH return a number?
Dates in Excel are numbers counted from 1900. Format the cell as a date and the number shows as one.

This task is in the timed finance and accounting practice tests. What Excel interview tests check

All challenges

  1. 01Starter, 3 min Add it upSUM
  2. 02Starter, 3 min Find the averageAVERAGE
  3. 03Starter, 3 min Smallest and largestMIN, MAX
  4. 04Starter, 3 min Count what's thereCOUNT, COUNTA, COUNTBLANK
  5. 05Starter, 3 min Write once, fill downRelative references
  6. 06Core, 3 min Lock it with $Absolute references
  7. 07Starter, 3 min Percent of a totalPercentages
  8. 08Starter, 3 min Make the numbers readableNumber formats
  9. 09Core, 3 min Up or down by how much?Percent change
  10. 10Core, 3 min What you see vs what's storedROUND
  11. 11Core, 3 min The typical valueMEDIAN
  12. 12Core, 3 min Select to the end in one moveCtrl + Shift + arrow
  13. 13Starter, 3 min Sort without breaking rowsSort
  14. 14Starter, 3 min Filter to what mattersFilter
  15. 15Starter, 3 min Copy and paste a formulaCtrl+C, Ctrl+V
  16. 16Core, 3 min Paste values onlyPaste Special → Values
  17. 17Core, 3 min Highlight what's over targetConditional formatting
  18. 18Core, 3 min Spot the duplicatesDuplicate Values rule
  19. 19Core, 3 min Pass or fail?IF
  20. 20Core, 3 min Both or either?AND, OR
  21. 21Core, 3 min Exactly one of the twoXOR
  22. 22Core, 3 min Grade bands with nested IFNested IF
  23. 23Core, 3 min Count the ones that matchCOUNTIF
  24. 24Core, 3 min Add up the ones that matchSUMIF
  25. 25Core, 3 min Use a cell as the conditionCriteria in a cell
  26. 26Core, 3 min Partial matches with * and ?SUMIF, COUNTIF with wildcards
  27. 27Core, 3 min Count with two conditionsCOUNTIFS
  28. 28Core, 3 min Add up with two conditionsSUMIFS
  29. 29Core, 3 min Look it upVLOOKUP
  30. 30Core, 3 min Find the right bracketVLOOKUP approximate match
  31. 31Core, 3 min XLOOKUP, the modern wayXLOOKUP
  32. 32Core, 3 min Where is it in the list?MATCH
  33. 33Advanced, 3 min INDEX and MATCH togetherINDEX + MATCH
  34. 34Advanced, 3 min Lock just the row or the columnMixed references
  35. 35Advanced, 3 min Growth per year (CAGR)CAGR with ^
  36. 36Core, 3 min Use a rate from another sheetReferences to other sheets
  37. 37Core, 3 min Catch the error, not the bugIFERROR
  38. 38Core, 3 min Which invoices are missing?Compare two lists
  39. 39Core, 3 min Reconcile the ledger with the bankXLOOKUP or VLOOKUP + IFNA
  40. 40Core, 3 min Join text together&, CONCAT, PROPER
  41. 41Core, 3 min Split first and last namesLEFT, MID + FIND
  42. 42Core, 3 min Stray spaces that break a countTRIM
  43. 43Core, 3 min Flag the bad entriesTRIM, LEN, EXACT
  44. 44Advanced, 3 min Clean a bank descriptionTEXTBEFORE, TEXTAFTER, PROPER
  45. 45Core, 3 min Mistake hunt: #N/A everywhereFixing #N/A
  46. 46Core, 3 min Mistake hunt: hard-coded numbersReferences instead of typed numbers
  47. 47Core, 3 min Mistake hunt: numbers stored as textNumbers stored as text
  48. 48Core, 3 min One of each, then the totalsUNIQUE
  49. 49Core, 3 min Your first pivot tablePivot tables
  50. 50Advanced, 3 min Which category went up most?SUMIFS, change, lookup
  51. 51Core, 3 min How many days late?Date arithmetic
  52. 52Core, 3 min Turn text into real datesDATEVALUE
  53. 53Advanced, 3 min Month ends and working daysEOMONTH, NETWORKDAYS
  54. 54Core, 3 min Renewal datesEDATE
  55. 55Core, 3 min Days overdue and aging bandsDate difference, aging bands
  56. 56Core, 3 min How many late orders?Pick the tool
  57. 57Core, 3 min Sales per repPick the tool
  58. 58Core, 3 min Whose part is it?Pick the tool
  59. 59Core, 3 min Who gets the bonus?Pick the tool
  60. 60Core, 3 min Each region's sharePick the tool
  61. 61Advanced, 3 min Case: the supplier reportCase, five steps
  62. 62Advanced, 3 min Case: the monthly budgetCase, five steps
  63. 63Advanced, 3 min Case: the reorder listCase, five steps

The whole course, in order.

The challenges teach one move each. The course puts them in order and makes you do each one twice, the second time on data you haven't seen.

$29 One time. No subscription. Early-access price. Get Pro for $29

Secure checkout on Stripe.

  • CourseAll 63 ready lessons in order, plus every one we add. The first 5 are free. Each formula lesson ends with a second round on new data, no hints.
  • TestsYour score on the interview practice tests is free. Pro adds the full report: what went wrong on each task, and the lesson for it.
  • 14 daysNot what you hoped for? Full refund within 14 days, no questions. Refunds

Pro isn't open right now

Checkout is closed for the moment, so nothing was charged. Leave your email and we'll write once when it opens. The price is $29, one time.

One email when Pro opens. Unsubscribe in one click. Privacy
Continue

Sign in or create an account

No password. Your solved challenges then follow you to any device.

Signing in sets one cookie that keeps you signed in. Privacy