Dear all,

Kindly provide me with a function or macro that can fill a column with month end dates only for the year.

E.g
Column A
31/01/2015
28/02/2015
31/03/2015
30/04/2015
31/05/2015
.....
......
.....
31/12/2015


Many thanks in advance

Chris