You can create a hidden cell which extracts the month from the date, and
then use that to search by months. You can do this by using the following
formula:
=TEXT(A1, "mmmm")
That will give you the month in text, which you can use in the "A word or
phrase in the file" box of the search assistant.
Hope that helped.
Shafiee.
"boyd" wrote in message
...
if i have 100 individually saved excell invoices, and i want to search by
dates and the format of those dates are as follows (1/1/2002) is there a
way
to search by months
|