Return month even if first sunday is in previous month?

So I have my date in A1. as 2/27/2011. my formula in B1=TEXT(A1,"mmmm"). This returns the month for a formula that uses indirect to find a *.xls. Problem is that If my fiscal month is ...say March, the month starts on 2/27/2011 which will make B2="February" which will not pull any data, as my sales plans for 2/27/2011 are in the "March" workbook! Any help would be greatly appreciated!

So Ive pretty much solved the problem. I didn't realize it but I had bigger problems. this was supposed to basic return what month and week a day was in. I got around this by creating a range with the first sunday of that week in A1. I then added down, A1+1,A1+2,A1+3,till I had my seven days of the week.

date year month day week #
2/27/2011 2011 March Sunday 1
2/28/2011
3/1/2011
3/2/2011
3/3/2011
3/4/2011
3/5/2011

put the following formula in column C under Month:
=TEXT(MEDIAN($A$2:$A$8),"mmmm")
This says whatever month has more day in this week, that is what month this is.

Then in column E under week# I put:
=IF(VALUE(TEXT(A2,"m"))=VALUE(TEXT(MEDIAN($A$2:$A$8),"m")),ROUNDUP((DAY(A2)+WEEKDAY(DATE(YEAR(A2),MONTH(A2),0)))/7,0),1)
This says if Sunday Month is not the month in C2 then it must be week 1

I then just link all my files to the above data! YAY!

Jordan