Excel Study · Module 7: Dates & times
Class 60EOMONTH: end of month
Intermediate1:57 videoFree
=EOMONTH(A2,0) gives the last day of the month of the date in A2, and =EOMONTH(A2,1) the last day of the next month — the due date when a client pays at the end of the following month.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A4 has an invoice date. Write a formula for B5 that gives the last day of the month that date is in.
The answer that works
✓ checked in Excel=EOMONTH(A4,0)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.