G
Geoff
What is the quickest way to get the days in a month in a series. Eg
31 Jan 2005
28 February 2005
31 Jan 2005
28 February 2005
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Put this in A1
=DATE(2005,ROW()+1,0)
And drag down 120 rows.
Format the cell as: dd mmmm yyyy
=DATE(2005,ROW()+1,0)
And drag down 120 rows.
Format the cell as: dd mmmm yyyy
B
Bob Phillips
bit unclear myself, but maybe format as ddd dd mmm yyyy
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
Dave Peterson
I wasn't sure how many columns???
Bob said:bit unclear myself, but maybe format as ddd dd mmm yyyy
--
HTH
RP
(remove nothere from the email address if mailing direct)
B
Bob Phillips
I got confused by the days and the dates, which was wanted ????
Bob
Bob