Days in month for 10 year period

's Computer Specifications

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

31 Jan 2005
28 February 2005

's Computer Specifications

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

's Computer Specifications

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

--

HTH

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

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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

's Computer Specifications

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

Bob

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate number of days in months given a multi-month time period	PF	Microsoft Access VBA Modules	5	9th Nov 2009 08:52 PM
YEAR MONTH DAYS COUNTER	ad2ad79	Microsoft Excel Worksheet Functions	2	13th Jun 2009 04:28 PM
Linking # of days to Period and Year	KrispyData	Microsoft Access Getting Started	5	9th Apr 2009 01:21 AM
Number of days in a month in any given year...	=?Utf-8?B?ViBSYW1vcw==?=	Microsoft Access VBA Modules	32	23rd Jul 2005 04:44 AM
Year, Month, Days	sajevan	Microsoft Excel Programming	2	23rd May 2004 07:28 AM