Monthend Dates Extraction
 

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

Monthend Dates Extraction
 

Hi Chris,

Am Mon, 23 Mar 2015 02:13:51 -0700 (PDT) schrieb :

Column A
31/01/2015
28/02/2015
31/03/2015
30/04/2015
31/05/2015

in A1 try:
=EOMONTH(DATE(YEAR(TODAY()),ROW(),1),0)
and copy down


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional