Kevin has attended:
Word Advanced course
Excel Intermediate course
Filtering dates
I have a spreadsheet with a list of approx 2000 dates. I would like to use a filter to sort out all of the dates that contain January. can this be done and if so how?
RE: Filtering dates
Hi Kevin
Thanks for your question.
Firstly, turn on the AutoFilter (Data-Filter-AutoFilter).
You can use the Custom Filter feature available through the AutoFilter to display only January dates.
How you set up the filter depends on how the dates have been entered.
If they are in the format dd/mm/yy, then you can use for example equals */01/06 as your filter (* is the wildcard which stands for a series of characters).
If your dates are in the format dd January yy then you can use contains January as your filter.
Hope this helps. Please post another forum question if not.
Thanks
Amanda
