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
