obc1126 wrote:

"Carim" wrote:

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?

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.