My company uses a fiscal calendar where the month ends on the 4th Friday of
every month except for the end of the quarters (March, June, Sep, and Dec)
which end on the 5th Friday. I have a column with various dates ranging from
01/01/06 through today and I'd like the fiscal calendar month name (or month
number) to show in the cell to the right of each date. Normally the =month()
function would work, but it can't with our fiscal month.

Can someone help me come up with a formula that I can use that'll serve the
same purpose? I'm trying to avoid a 24 layer nested if statement because the
formula will often be copied 2003 excel.

Thanks, Jon