Gary,

That is because my formula counted the date as well (yes I know, that is
dumb <g), so you need to offset the start point by 1 column, which is what
you mod did.

The OFFSET arguments are
- start cell
- number of rows to offset
- number of columns to offset
- number of rows to reference
- number of columns to reference

so the formula

=COUNT(OFFSET(Sheet2!B8,MATCH(TODAY(),Sheet2!B8:B3 9,0)-1,1,1,255))

starts at B8, MATCHes the date against the dates B8:B39 and uses that as the
number of rows to offset, so it effectively starts at that number of rows
past B8, offset 1 column (so as to not count the date), and then counts
within a range of 1 row and 255 columns from that point.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gary m" wrote in message
...
Bob:
The correction you provided re 255 columns was right, however the correct
string turned out to be -1,1,1,255 - using 1 instead of 0. Using this
string
and testing it, the answers are correct. Still trying to understand whole
string so can't tell why it works yet but that is correct string.
Appreciate
all the help. Thanks,
Gary

"gary m" wrote:

I have an Excel summary sheet that retrieves daily data from
departmental
sheets based on date search (eg. TODAY()-1,etc.. I need a formula that
will
go to the sheet, search for the date and then "Count" the cells in
columns
next to the date that have data. I have used vlookup to find specific
cells
but can't seem to 'count' multiple cells/columns next to the date. As
you can
see, I am somewhat an inexperienced user. Thanks for the help.