My own fiscal year

O

obc1126

Is there a way to define my own fiscal year that was different form the
normal calendar?I wanted the month to automatically 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?

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
 
C

Carim

Hi,

Just sort properly your dates, and use your table as the reference
table of your lookup() function ...

HTH
 
O

obc1126

Carim said:
Hi,

Just sort properly your dates, and use your table as the reference
table of your lookup() function ...

HTH


How to sort out the dates? How should i define the start date and the end
date? The start sate & end sate should be in the same cell or different cell?
 
S

smartin

obc1126 said:
How to sort out the dates? How should i define the start date and the end
date? The start sate & end sate should be in the same cell or different cell?

I strongly suggest using separate cells. Set it up in columns, like

A B C
Start End Fiscal Month
1/25/09 2/21/09 Feb
10/19/08 11/22/08 Nov

Then you can use formulas to determine the Fiscal Month, based on if a
given date falls between Start and End.
 
O

obc1126

smartin said:
I strongly suggest using separate cells. Set it up in columns, like

A B C
Start End Fiscal Month
1/25/09 2/21/09 Feb
10/19/08 11/22/08 Nov

Then you can use formulas to determine the Fiscal Month, based on if a
given date falls between Start and End.

How to do comparison based on dates?

Will this work?
If date>=columnA & <=columnB
Then WorkMonth=columnC

Can somebody show me how to write the code?

Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top