Complicated IF Dilema

[sco315]

This may sound a little confusing so bear with me. I have one workbook with around 30 or so worksheets. Each worksheet has a goal for each month and keeps track of the progress made to date. On the final page, I compare each goal to what has been completed depending on the month. However, I don't want to manually switch what cell is used month to month. I want to have a code so that depending on the date accessed (today's date) is selects the correct cell for my equations.



Thanks,
Steve

 

[Asala42]

I suspect you'll end up using the INDIRECT function to convert today's date into a desired sheet name (presumably month and year names).

Instead of this (manually changed every update):
='May 2015'!D14

You could replace that with this:
=INDIRECT("'"&TEXT(EOMONTH(TODAY(),-2)+1,"mmmm yyyy")&"'!D14")

The second formula would always look in D14, but only on a sheet with a name of the previous month from today's date.