Countifs reference to sheet name as today's date

[akasmora]

Dear all,

I need to count of some cells on daily basis, I need to refer to today's date sheet.

This sheet will have name as today's date (say Apr-24-13) so i need to refer this sheet.. I need some formula like below..

COUNTIFS(today()!$C$4:$C$13,today()!C15)

I need to set the formula so that I need not change the formula on daily basis.

Have I made myself clear about the problem?

Regards

 

[Marcelo Branco]

Maybe something like this

=COUNTIF(INDIRECT("'"&TEXT(TODAY(),"mmm-dd-yy")&"'!$C$4:$C$13"),INDIRECT("'"&TEXT(TODAY(),"mmm-dd-yy")&"'!$C$15"))

Remark: the sheets for days with only one digit must be named as
May-01-13
May-02-13
....
May-09-13

M.