How to use EOMONTH in Google Sheets
End of the month
How EOMONTH works
EOMONTH returns the last day of a month. The second argument moves months: 0 is the same month, 1 the next, -1 the one before.
Days left in February after the order placed on 2/2/2026.
What you’ll do
You’ll find how many days were left in the month after an order came in. Month-end dates matter for billing, payroll and reports, and EOMONTH saves you remembering which months have 30 days.
Try it
Type =EOMONTH(G4,0)-G4 into K2 and press Enter. Watch what the sheet does.
The result will appear in K2.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Rep | Region | Product | Units | Price | Order date | Ship date | |||
| 2 | 1001 | Ana | West | Desk | 3 | 240 | 1/5/2026 | 1/9/2026 | |||
| 3 | 1002 | Bo | East | Chair | 8 | 85 | 1/12/2026 | 1/20/2026 | |||
| 4 | 1003 | Cy | West | Lamp | 12 | 30 | 1/19/2026 | 1/22/2026 | |||
| 5 | 1004 | Di | North | Desk | 2 | 240 | 2/2/2026 | 2/13/2026 | |||
| 6 | 1005 | Ana | West | Chair | 5 | 85 | 2/9/2026 | 2/12/2026 | |||
| 7 | 1006 | Eve | South | Shelf | 4 | 120 | 2/16/2026 | 2/27/2026 | |||
| 8 | 1007 | Bo | East | Lamp | 20 | 30 | 3/2/2026 | 3/4/2026 | |||
| 9 | 1008 | Cy | West | Shelf | 1 | 120 | 3/9/2026 | 3/18/2026 | |||
| 10 | 1009 | Di | North | Chair | 6 | 85 | 3/16/2026 | 3/19/2026 | |||
| 11 | 1010 | Eve | South | Desk | 7 | 240 | 3/23/2026 | 4/1/2026 |
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how EOMONTH works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
In K2, work out how many days are left in the month after the row 2 order was placed.
One payment, no subscription.