Lesson 24 of 45, Dates
EDATE, EOMONTH & NETWORKDAYS
Quick answer
Add months, find month-ends and count business days.
- Key formula
=EDATE(B2,C2)(Start + N months)
Watch it done
4 stepsWatch the technique worked out on sample data, then try it yourself in the exercises.
How it works
Add days with plain +. Add months with EDATE(start, months), which handles short months: one month after January 31 is February 28.
EOMONTH(start, 0) is the last day of that month; use 1 for next month. NETWORKDAYS(start, end) counts Monday to Friday, inclusive, and takes an optional holiday list. For ages and tenure, DATEDIF(start, end, "Y") gives whole years.
Syntax
=EDATE(B2,C2)Start + N months=EOMONTH(B2,0)Month-end=NETWORKDAYS(B2,D2)Business days, inclusive=DATEDIF(B2,TODAY(),"Y")Whole years elapsedWatch out for
- A result like 46219 means the cell isn't formatted as a date yet.
- NETWORKDAYS counts both the start and end day.
The exercises
- Contract end dates. In D2, calculate each contract's end date: the start date plus the term in months. Fill down to D6.
- Bill at month-end. In E2, return the last day of each contract's start month. Fill down to E6.
- Business days. In F2, count the weekdays from each start date to its end date. Fill down to F6.
Questions people ask about this
- How to build a summary table with SUMIFS in Excel
- How to calculate the number of working days in a month in Excel
- How to list semi-monthly pay dates (the 15th and last day) in Excel
- How to calculate how many days of a date range fall in each month in Excel
- How to add months to a month-end date and stay at the end of the month in Excel
- How to sum by month in Excel
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .
Graded practice for this lesson is part of Pro
The walkthrough and notes are open to everyone. Pro unlocks the exercises here and in the other 43 Pro lessons, Excel and Google Sheets, 125 exercises in all.
- Contract end dates
- Bill at month-end
- Business days