MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I count record occurances base on date.


Posted by Steve on December 11, 2001 9:59 AM

I need to be able to count records in my excel file that meet date criteria. i.e. =>12/1/00 AND <1/1/01. Does anyone have any ideas? I'm stumped.


Posted by Aladin Akyurek on December 11, 2001 10:31 AM

Steve --


=COUNTIF(A1:A10,">="&C1)-COUNTIF(A1:A10,">="&C2)

where A1:A10 houses dates data, C1 the first condition/criterion date, and C2 the second condition date (C2 > C1).

Aladin

Posted by Steve on December 11, 2001 11:19 AM

Aladin,
Thank you for the help.
Steve