Page 142 - Ms Excel Note and Workbook
P. 142
MICROSOFT EXCEL NOTE AND WORKBOOK
4. The Custom AutoFilter dialog box will appear. Enter the desired date(s) to the right of
each filter, then click OK. In our example, we want to filter for dates after or equal
to July 15, 2015, and before or equal to August 15, 2015, which will display a range
between these dates.
TIP
Use custom auto filter
dialog box for the selected
date filter
5. The worksheet will be filtered by the selected date filter. In our example, we can now
see which items have been checked out between July 15 and August 15.
133 | P a g e