I want to fill column names with a sequential list of the last day of each month. For example,
5/31/2018, etc. Is there a formula that can do this? If cell B1 =
3/31/2018, I tried this:
=DATE(YEAR(B1), MONTH(B1)+1, DAY(B1))
But this produces
5/1/2018 since April has only 30 days.