Find end of month with EOMONTH
BeginnerIn accounting, payment terms like "net end of next month" mean the invoice is due on the last day of the month after it was issued. The exact date varies by month, which makes it tricky to calculate by hand.
The EOMONTH function handles this for you. It returns the last day of a month that is a given number of months away from a start date.
Syntax:
=EOMONTH(start_date, months)
For example, =EOMONTH("2025-03-10", 1) returns the last day of April: April 30, 2025. Use months = 0 to get the end of the same month, or months = -1 for the previous month.
What you need to do:
- Click cell D2.
- Write a formula using EOMONTH to return the last day of the month after the issue date in B2. Use 1 as the months argument.
- Press Enter. The result may appear as a number. If it does, format column D as a date.
- Fill the formula down from D2 through D11.
Need some help?
Hint 1
Watch out for a common mistake: using 0 as the second argument returns the last day of the same month as the issue date, not the following month. Make sure to use 1 to get end of next month.
Hint 2
Once you have the formula in D2, you can fill it down to the remaining rows by selecting D2 and dragging the small square at the bottom-right corner of the cell down to the last row.
Find end of month with EOMONTH
BeginnerIn accounting, payment terms like "net end of next month" mean the invoice is due on the last day of the month after it was issued. The exact date varies by month, which makes it tricky to calculate by hand.
The EOMONTH function handles this for you. It returns the last day of a month that is a given number of months away from a start date.
Syntax:
=EOMONTH(start_date, months)
For example, =EOMONTH("2025-03-10", 1) returns the last day of April: April 30, 2025. Use months = 0 to get the end of the same month, or months = -1 for the previous month.
What you need to do:
- Click cell D2.
- Write a formula using EOMONTH to return the last day of the month after the issue date in B2. Use 1 as the months argument.
- Press Enter. The result may appear as a number. If it does, format column D as a date.
- Fill the formula down from D2 through D11.
Need some help?
Hint 1
Watch out for a common mistake: using 0 as the second argument returns the last day of the same month as the issue date, not the following month. Make sure to use 1 to get end of next month.
Hint 2
Once you have the formula in D2, you can fill it down to the remaining rows by selecting D2 and dragging the small square at the bottom-right corner of the cell down to the last row.