A client wants two column headings to read:
2008/2009
and
2009/2010
Their fiscal year-end is 8/31/2010. What formula can I use so that no matter what period they select for FY 2009/2010, I get these two headings?
As a start, I was able to get 2009 to appear for all periods by using the formula =GLFPE("NET_[8]M","YYYY"). I wasn't able to get 2008 or 2010 by itself.
Thanks