Dond,

Try this

=COUNTIF(H34:H44,"<="&Sheet2!N2)-COUNTIF(H34:H44,"<"&TODAY())

--
HTH

Bob Phillips

"dond" wrote in message
...

Im working on two sheets
On sheet 1, I wish cell e37 to enter the number of times a date is
placed in the column h34:h44. (These dates will be randomly entered
manually later)

The dates will fall on or between the current day "today()" and a date
enntered in sheet 2, cell N2

Every syntax I try falls over and I keep getting zero values in E37.
Its got to be easy but it escapes me. Any help out there?


--
dond
------------------------------------------------------------------------
dond's Profile:
http://www.excelforum.com/member.php...o&userid=25477
View this thread: http://www.excelforum.com/showthread...hreadid=393816