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

Hi Steve,

On the assumption that you'd like the column headings to adjust based on the year that the statement is being printed for, this formula should accomplish what you're looking for:

There are lots of ways of doing this. This one was the first that sprang to mind.

If you'd like to force a line break between the years, use "\n" in the string concatenation.

Hi Andrew

Correct assumption.

That works for 2008 and 2009.  To get 2010 I used GLFPE("[12]M","YYYY"). I'm all set.

Thanks

Steve