Did you try it?
In article ,
Ken wrote:
If you do want to use an actual date in the formula, I believe that you have
to use DATEVALUE:
....--(B1:B100=DATEVALUE("14/01/05"))
"JE McGimpsey" wrote:
One way:
=SUMPRODUCT(--(A1:A100="Bananas"), --(B1:B100=TODAY()))
|