To assign month for a certain range of date

O

obc1126

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?
 
B

Bob Phillips

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

obc1126

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

obc1126

:

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?
 
Top