=COUNTA(INDIRECT("A1:A"&DAY(TODAY())))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don" wrote in message
...
I have a column of numbers, 1-31. Each number is the number of a day of
the
month. Some days are missing and a blank has been left for those days (in
the column).
Can someone help me with this problem? I want to return the count for the
days that are listed (omitting the blanks) but I only want to count the
days
that are less than or equal to =day(today()). Can someone show me how to
write this? It's driving me mad. Thanks for any help.
--
Don Rountree