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
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