=EOMONTH(start_date, months)
=EOMONTH(B5,0)
The function can be used to find the end of a month by adding a certain number of months to a given date. In the example given, the result is the end of that month, May 31, 2017.
=EOMONTH(B5,4)
The function can also be used to find the end of a month by adding a certain number of months to a given date. In the example given, this results in the end of that month, September 30, 2017.
The EOMONTH function is a useful tool for calculating dates that fall on the last day of a month or the first day of the next month. It takes a year as an argument and returns the corresponding serial number for the last day of the month.