Countif to count items within a range of dates !!PLEASE HELP!!
Posted by Ryan on May 24, 2000 9:46 AM
I have a large list of outstanding checks(31k rows) including 3 columns listing the check#,check date and the batch that the checks were done in. I need to count the number of checks within a given date range. I can use the countif to get the results of one day as follows:
That will work ok for one date, but how would I get the results of lets say, all of April 2000? Any help is greatly appreciated.
PS. Please copy in response to my email addy(Ryan.Kamp1@firstunion.com