I have the following formula

=COUNTA('4-6'!A:A)-1

where the worksheet name is '4-6'

However I want to use the INDIRECT function as I need to repeat this for multiple sheets and they all have different names based on a date. The date is in cell B2... and I thought the following would work:

=COUNTA(INDIRECT("'"&DAY(B2)&"-"&MONTH(B2)&"'!A:A)-1"))

However this brings the wrong value.

I have also tried:

=COUNTA(INDIRECT("'"&DAY(B2)&"-"&MONTH(B2)&"'!A:A)")-1)

This doesn't give the correct answer either.

Any idea of where I am going wrong?

Thanks