Microsoft Office Tutorials and References
In Depth Information
Figure 9-21 shows another example. This criteria range displays listings from the month of August, 2012.
Notice that the column name (Date Listed) appears twice in the criteria range. The criteria selects the records in
which the Date Listed date is greater than or equal to August 1, and the Date Listed date is less than or equal to
Figure 9-21: This criteria range selects records that describe properties that were listed in the month of
The date selection criteria may not work properly for systems that don't use the U.S.
date formats. To ensure compatibility with different date systems, use the DATE func-
tion to define such criteria, as in the following formulas:
To join criteria with a logical OR operator, use more than one row in the criteria range. A criteria range can
have any number of rows, each of which joins with the others via an OR operator. Figure 9-22 shows a criteria
range (A1:C3) with two rows of criteria.