To assign month for a certain range of date
 

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?

To assign month for a certain range of date
 

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

--
__________________________________
HTH

Bob

"obc1126" wrote in message
...

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?

To assign month for a certain range of date
 

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" wrote in message
...

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?

To assign month for a certain range of date
 

"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" wrote in message
...

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?