Days in month for 10 year period

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

31 Jan 2005
28 February 2005

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

Format the cell as: dd mmmm yyyy




Geoff wrote:
>
> What is the quickest way to get the days in a month in a series. Eg
>
> 31 Jan 2005
> 28 February 2005

--

Dave Peterson

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

--

HTH

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


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Put this in A1
> =DATE(2005,ROW()+1,0)
> And drag down 120 rows.
>
> Format the cell as: dd mmmm yyyy
>
>
>
>
> Geoff wrote:
> >
> > What is the quickest way to get the days in a month in a series. Eg
> >
> > 31 Jan 2005
> > 28 February 2005
>
> --
>
> Dave Peterson

I wasn't sure how many columns???

Bob Phillips wrote:
>
> bit unclear myself, but maybe format as ddd dd mmm yyyy
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Put this in A1
> > =DATE(2005,ROW()+1,0)
> > And drag down 120 rows.
> >
> > Format the cell as: dd mmmm yyyy
> >
> >
> >
> >
> > Geoff wrote:
> > >
> > > What is the quickest way to get the days in a month in a series. Eg
> > >
> > > 31 Jan 2005
> > > 28 February 2005
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

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

Bob

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> I wasn't sure how many columns???
>
> Bob Phillips wrote:
> >
> > bit unclear myself, but maybe format as ddd dd mmm yyyy
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> > "Dave Peterson" <[email protected]> wrote in message
> > news:[email protected]...
> > > Put this in A1
> > > =DATE(2005,ROW()+1,0)
> > > And drag down 120 rows.
> > >
> > > Format the cell as: dd mmmm yyyy
> > >
> > >
> > >
> > >
> > > Geoff wrote:
> > > >
> > > > What is the quickest way to get the days in a month in a series. Eg
> > > >
> > > > 31 Jan 2005
> > > > 28 February 2005
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson