Group: microsoft.public.excel.misc · Group Profile · Search for Naturual in microsoft.public.excel.misc
Author: Bob Phillips
Date: Apr 23, 2008 16:19
=COUNTIFS(B8:B19,">=4/1/2008",B8:B19,"<=4/18/2008") Countifs will give you the opportunity to set more than 1 criteria. In the example above, the range of cells with dates is B8:B19 and the result will be the total number of dates that meet the 2 criteria. The equal sign is only to say greater than OR equal to. The date format is month/date/year in the example also. "Mike" wrote:
|