First, Eomonth function syntax
Function: Returns the series number of the last day of the specified month before or after Start-date.
The implication is that, given a time start_date, and then, given a month months, you can calculate the start_date this time before the month or the last day of the month.
Start_date is a date that represents the start date. Dates can be entered in several ways: quoted text strings (for example, "1998/01/30"), number of series (for example, if you use the 1900 date system, 35825 means January 30, 1998) or the results of other formulas or functions (for example, DATEVALUE ("1998/1/30")) 。
Month is the number of months before or after start_date. A positive number indicates a future date, and a negative number represents the past date.
We can also understand the EOMONTH function as follows: EOMONTH (given date, forward or backward month number)
Examples of the use of Eomonth functions
Like the formula:
①=eomonth ("2011-8-1",-2), returned the result is: June 30, 2011
Why did you get the result? Because the given reference date is 2011-8-1, the last day of the two months before this date, that is, the two months preceding the 2, then it should be June 30, 2011.
②=eomonth ("2011-9-10", 1), let's analyze it, what is the result of the return?
First of all, we know that the reference date is 2011-9-10, and 1 is a positive number, representing the one months before the date, of course, October.
Therefore, the function returns the last day of the one months preceding 2011-9-10, that is, October 31, 2011.
Let's look at one more example:
=eomonth ("2012-1-1",-5), the reference date is 2012-1-1,-5 represents the last day of the one months of the five months preceding the reference date, so it should be August 31, 2011.
Iii. considerations for the use of function eomonth
① about cell settings
Because the function returns data of the date type, you need to format the cells you use to date type. Otherwise, you will not see the correct result.
② about why a function cannot be used
When you use the Eomonth function, you may not be able to use it correctly, or you will not get the correct result, because the function is not a common function, you must use the following methods to solve.
The Add-ins command on the Tools menu starts.