ExcelBanter - Criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Criteria (https://www.excelbanter.com/excel-worksheet-functions/158920-criteria.html)

Caroline

Criteria

I'm trying to do a countif function where my criteria is a date range, like
between 8/1/2007 and 8/31/2007.
Thanks for your help!

Peo Sjoblom

Criteria

=COUNTIF(A2:A100,"="&DATE(2007,8,1))-COUNTIF(A2:A100,""&DATE(2007,8,31))

or

=SUMPRODUCT(--(A2:A100=DATE(2007,8,1)),--(A2:A100<=DATE(2007,8,31))

--

Regards,

Peo Sjoblom

"Caroline" wrote in message
...
I'm trying to do a countif function where my criteria is a date range,
like
between 8/1/2007 and 8/31/2007.
Thanks for your help!

All times are GMT +1. The time now is 03:56 PM.