A coworker had a pretty complex spread sheet with several sheets in it.
One sheet had monthly and yearly totals going back to 2003.
She wanted a chart on a new sheet that compared this year's data with previous years.
But only up to the current months data... so August 2009 compared to Aug. 08, Aug. 07, etc
Here is what I came up with:
=INDIRECT(ADDRESS(104,MONTH(TODAY()),4,1,"damages per 1000"))
I am far from an excel expert so I'm proud of it.
Luckily the sheet with the monthly totals is arranged so that month 1 is in col 2 etc.