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