BAL[12]M returns December 31, 2012. I want it to return December 31, 2011 no matter what period I select in FY 2012

Of course, this has to work for future years. I was only giving 2012/2011 as an example.

Steve