'COUNTIFS(a1,">"&NOW(),a2,"="&"")'
"NOW() returns Date only whereby using "TODAY()" returns Date & Time which
may be your problem.
HTH
Mark.
Hope this helps.
Pete
=TODAY()=INT(TODAY())
=NOW()=INT(NOW())
return, respectively
TRUE
FALSE
Was this thread really started on 11/16/2007? At this point, 2/15/08
is < TODAY(). Also, a somewhat odd usage of COUNTIFS, normally you'd
expect a range to be used for the odd argument.