How to i assign month to a certain range of date that was not the same from
the normal calendar?

For example i want to assign the range of date from 9/21/08 to 10/18/08 to
be Oct. How do i do that?

Some of those are already October, do they become November or stay as
October?

--
__________________________________
HTH

Bob

"obc1126" <(E-Mail Removed)> wrote in message
news:683AEA4E-5D56-4062-8136-(E-Mail Removed)...
>
> How to i assign month to a certain range of date that was not the same
> from
> the normal calendar?
>
> For example i want to assign the range of date from 9/21/08 to 10/18/08 to
> be Oct. How do i do that?

Start from 10/19/08 to 11/22/08 will be Nov, 11/23/08 to 12/27/08 will be
Dec,......

"Bob Phillips" wrote:

> Some of those are already October, do they become November or stay as
> October?
>
> --
> __________________________________
> HTH
>
> Bob
>
> "obc1126" <(E-Mail Removed)> wrote in message
> news:683AEA4E-5D56-4062-8136-(E-Mail Removed)...
> >
> > How to i assign month to a certain range of date that was not the same
> > from
> > the normal calendar?
> >
> > For example i want to assign the range of date from 9/21/08 to 10/18/08 to
> > be Oct. How do i do that?
>
>
>

"obc1126" wrote:

Here's the list of my fiscal year ;
Date Month
From 1/25/09 to 2/21/09 Feb
From 10/19/08 to 11/22/08 Nov
From 11/23/08 to 12/27/08 Dec
From 12/28/08 to 1/24/09 Jan
From 2/22/09 to 3/28/09 Mar
From 3/29/09 to 4/25/09 Apr
From 4/26/09 to 5/23/09 May
From 5/24/09 to 6/27/09 Jun
From 6/28/09 to 7/25/09 Jul
From 7/26/09 to 8/22/09 Aug
From 8/23/09 to 9/26/09 Sep
From 9/21/08 to 10/18/08 Oct


I wanted the month to automtically appear when i enter the date. I know we
can make use of the date function for a normal date, is there any formula or
codes that i can define my own fiscal year?



>
> "Bob Phillips" wrote:
>
> > Some of those are already October, do they become November or stay as
> > October?
> >
> > --
> > __________________________________
> > HTH
> >
> > Bob
> >
> > "obc1126" <(E-Mail Removed)> wrote in message
> > news:683AEA4E-5D56-4062-8136-(E-Mail Removed)...
> > >
> > > How to i assign month to a certain range of date that was not the same
> > > from
> > > the normal calendar?
> > >
> > > For example i want to assign the range of date from 9/21/08 to 10/18/08 to
> > > be Oct. How do i do that?
> >
> >
> >