How to use the EOMONTH function
The EOMONTH function returns an Excel date for the last day of a given month using a number and a start date.
Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
Formula in cell C3:
Excel Function Syntax
EOMONTH(start_date, months)
Arguments
start_date | Required. A date that represents the starting date. Don't use text dates, use Excel dates, see comments below. |
months | Required. A number that determines how many months before or after the start date. A negative value returns a date earlier than the start_date. |
Comments
Excel dates are actually numbers formatted as dates. January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
The DATE function allows you to return an Excel date in the EOMONTH function. =EOMONTH(DATE(2008,1,1),2) returns 3/31/2008.
'EOMONTH' function examples
The following article has a formula that contains the EOMONTH function.
Question: How to calculate the date of the third Monday of a given month? Answer: Column B contains dates of […]
Functions in 'Date and Time' category
The EOMONTH function function is one of many functions in the 'Date and Time' category.
3 Responses to “How to use the EOMONTH function”
Leave a Reply to DURGA SHANKAR TANWAR
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Your eomonth ccalculation will be wrong
date of birth
01-06-1965
after 60 years
date will be display your command and function = 30-06-1965
but real answar = 31-05-2025
Your eomonth ccalculation will be wrong
date of birth
01-06-1965
after 60 years or 720 month
date will be display your command and function = 30-06-1965
but real answar = 31-05-2025
DURGA SHANKAR TANWAR
This is what I get: