Days in month for 10 year period

[Geoff]

What is the quickest way to get the days in a month in a series. Eg

31 Jan 2005
28 February 2005

 

[Dave Peterson]

Put this in A1
=DATE(2005,ROW()+1,0)
And drag down 120 rows.

Format the cell as: dd mmmm yyyy

 

[Bob Phillips]

bit unclear myself, but maybe format as ddd dd mmm yyyy

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

I wasn't sure how many columns???

bit unclear myself, but maybe format as ddd dd mmm yyyy

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

I got confused by the days and the dates, which was wanted ????

Bob