Fiscal Month Calculation

Hello Everyone,

I am hoping someone may be able to help with a formula to calculate the fiscal month based on a date. My fiscal months always start on the 22nd and ends on the 21st. Example: December 22nd - January 21st will be the fiscal month of January. January 22nd - February 21st will be the fiscal month of February, ending with Nov 22nd - Dec 21st being December.

The formula will be based on lets say A2 containing the date the record was added and then B2 will display the fiscal month using the dates above.

Any help is appreciated and thank you

Gerry

January 22nd - February 21st will be the fiscal month of January. don't you mean February?
however create a table of all the 22 of the month to what month thats in then use a look up see attached

note if you get a #name? error activate the analysis toolpak i used eomonth(a1,0)+22 to generate the 22nds
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

If you just want the month abbreviation then with date in A1 you can get the fiscal month with this formula

=IF(A1="","",TEXT(EDATE(A1-21,1),"mmm"))

or without using Analysis ToolPak functions

=IF(A1="","",TEXT(DATE(YEAR(A1-21),MONTH(A1-21)+1,1),"mmm"))

that's alot easier! both of you