Replace table name in formula with variable

[macfoo]

I'm using Microsoft's Employee Absence Schedule template for tracking.

There are references to tblMonthName that look like this in formulas

tblJanuary
tblFebruary
tblMarch

and so on.

An example of one of the formulas looks like this:

=COUNTIF(tblJanuary[@[1]:[31]],"V")

Because of some modifications I am doing (like the one above), I'd like to know if there is a way to make this dynamic, in determining the "table name" from the sheet that you are on.
Even better would be if it could also dynamically determine the "day range" of the month.

I tried concatenate for the table name in another cell (since the month name is provided in the sheet in a set cell across all 12 months) but was unable to figure out how to get it to work within the formula.

Thanks in advance

 

[friel300]

Hey man,

this formula will give you the current sheet name (as long as the workbook is saved.)

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

then you could use Indirect to give you the function you had in the result of the formula you have above.

=COUNTIF(INDIRECT(RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))&"!"&"1:31"),"V")