How is the column selected - is it dependent on TODAY() ?

What formulae have you tried?

"Charlie Brown" wrote:

Hi,

Using Excel 2003. I want to count the number of 'TRUE' cells to the left of
a column in a dynamic table. By dynamic, I mean that the column header is
date sensitive so that the date in A1 has A1+1 in col B etc. and as the date
advances along the table, the number of TRUE value cells to the left of
today's date in the table will increase. I tried doing a count using the
TODAY() function but that didn't work, I also tried to figure out how to
find today's date using FIND but I am not getting very far. I can't really
think of much more. Some help appreciated.

TIA

Charlie