countif function hassle

[dond]

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?

 

[Bob Phillips]

Dond,

Try this

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

 

[Guest]

dond,

Sounds like your problem might be that you're counting an exact day when
your date list might have decimal places which aren't showing. That is,
you're trying to count "August 1, 2005" when your list includes "August 1,
2005 10:03AM", so they aren't counted.

Eric