Last day of each month – Formula required

[grady121]

At the end of each year, I want to try and set up a template that shows the last day of each month for the following year. (Meter Reading)

I suppose what I’m ideally looking for, is perhaps some way of entering a formula (using VBA) in cell “D15” that I copy down the following 11 rows, to produce an end date for the 12 months of the new year. I could start with a default 01/01/**** if it helps - (**** indicates the new year)

I’d be grateful if anyone has any ideas in how to achieve this, preferably using VBA.

 

[narendra]

Enter below formula in cell A1:

=EOMONTH(--ROWS(A$1:A1)&-2017,0)

and copy/fill down till 12th row.

Format the cells as date. To get the cell format dialog box, right-click and select cell format or select cells range and press Ctrl+1

Hope this helps.

 

[grady121]

Thanks narendra,
Works like a charm.

Exactly what I needed.

 

[narendra]

You're welcome. I am glad I was able to help.