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!