autofilter with range of partial dates
Thanks Roger,
Yes the purpose of the yyyy was to cover all the years as for anniversary
only month & days are important.
So autofilter will not work with ???? ?
I assume then that I need to fill a column with only "mm-dd" information to
be able to solve this ?.
"Roger Govier" wrote:
Hi Francois
I'm not sure whether you are putting ???? into your criteria or not, but if
you are then autofilter won't work.
Try setting criteria 1 to greater than or equal to 2004-07-16 and criteria 2
to less than or equal to 2004-07-23.
If you do need the data across a range of years, set up a helper column with
a formula =YEAR(A1) (assuming your dates are in column A) and then also
filter on this column for the years required.
--
Regards
Roger Govier
"François" wrote in message
...
Hello,
I'm trying to code an autofilter to retrieve the people having there
anniverseray this from today up to 7 days.
Date are organized as yyyy-mm-dd in the column.
I'm not able to set working the autofilter like criteria1 "????-07-16"
and
criteria2 < "????-07-23" for ex.
Where is the solution.
Many thnaks to all of you.
|