EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel
The following article introduces you to the EOMONTH function - one of the functions in the date and time group function is very popular in Excel.
Description: The function performs the calculation and returns the last day in the month before or after 1 day of a specified number of months.
Syntax: EOMONTH (start_date, months)
Inside:
- start_date: The date represents the start date to calculate the last day of one or more months before or after, is a required parameter.
- months: Number of months you want to calculate, is the required parameters with the following cases:
+ months> 0 -> Create new days in the future.
+ months <0 -> Create new date in the past.
Attention:
- Excel stores the date as a serial number to facilitate the calculation process.
- If the start_date value is not a valid date -> the function returns the #VALUE! Error value
- Where start_date plus moths create an invalid date -> the function returns the #NUM! Error value
For example:
Calculate the last day in the month before or after a specific number of months in the table below:
- In the cell to calculate enter the formula: = EOMONTH (E7, F7).
- Press Enter -> the last day of the month before 1/1/2011 1 month is:
- Similarly copy the formula with the same value but the opposite month argument results. So with months <0 in the past:
- Copy the formula for the remaining values to get the result:
- Where the value of months is not an integer -> it is truncated to an integer:
Above are instructions and some specific examples when working with EOMONTH function in Excel.
Good luck!
You should read it
- MONTH function - The function converts a serial number into a month in Excel
- MONTH function in SQL Server
- DAY function in SQL Server
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- The DAY function - The function returns the day of the day, month and year in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
- The DAYS function - The function returns the number of days between 2 dates in Excel
May be interested
- EDATE function - Add and subtract months to a specified date in Exceledate function: the function that adds (subtracts) months on a specified date. use this function to calculate the due date that matches the release date in the month. syntax: edate (start_date, months)
- ISODD function - The function returns True if the value is an odd number in Excelisodd function: the function returns true if the value is odd. application of functions to check odd and even numbers. syntax: isodd (number)
- PERMUTATIONA function - The function returns the number of permutations (can be repeated) of a given object in Excelpermutationa function: the function returns the number of permutations (can be repeated) of a given object. support functions from excel 2013 onwards. syntax: permutationa (number, number_chosen)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excelrank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
- SHEETS function - The function returns the number of pages in a reference in Excelsheets function: the function returns the number of pages in a reference. support functions from excel 2013 onwards. syntax: sheets (reference)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- The SQRT function returns the square root of a positive number in Excelthe sqrt () function in excel helps you quickly calculate the square root of any number you want. the syntax and usage of the function is very simple, but if you do not know, follow the article below.
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.