countifs function

[Felsa Satlow]

My understanding of this function is that it ANDs multiple criteria.
So, I have a worksheet that has a date (2/15/08) in cell a1 and cell
a2 is blank. Cell a3 has 'COUNTIFS(a1,">"&today(),a2,"="&"")'. Cell 3
shows 0 instead of 1, as I expected. Does anyone know why?

 

[NoodNutt]

I have just started using 2007 myself, and your the second person I have
noticed using "Today()", I have always known date functions as Now().

'COUNTIFS(a1,">"&NOW(),a2,"="&"")'

"NOW() returns Date only whereby using "TODAY()" returns Date & Time which
may be your problem.

HTH
Mark.

 

[Pete_UK]

Check it out in Excel Help - it's actually the other way round.
TODAY() returns the date only, NOW() returns date and time.

Hope this helps.

Pete

 

[ilia]

Easy enough to check.

=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.