← Back to level 2
Level 2Next
EOMONTH
A medium date formula for jumping to the last day of a month by a given offset.
Syntax
=EOMONTH(...)Step-by-step explanation
- 1Use a date or time formula when the result should update automatically.
- 2Place the function in the cell where you need a live date or time value.
- 3Format the cell if needed so the output is easy to read.
Common mistakes
Forgetting the month offset changes the target month
Using it when you need the first day instead
Not formatting the result as a date
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=EOMONTH(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =EOMONTH(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use EOMONTH when month-end reporting or billing needs the final day of a period.
Match against the syntax block above.