Generating a series of dates with the EOMONTH function

You will sometimes need to generate a series of dates in Excel. Most often you will need month-end dates, but no matter what kind of dates you need, the simplest way to generate them will include the EOMONTH function. The EOMONTH function returns the last day of the month in relation to the start date.   The EOMONTH function syntax is as follows: = EOMONTH ( start_date; number of months ) Start date is any given date, such as 31.12.2020.