Filter Dates?
the date may be formated as mm/dd/yy but it does not actually start with the
month
I suggest using a helper column with =month(A1) and use the autofilter on
this column.
"Ken" wrote:
Excel2003 ... I have a Col containing Dates ... Format = Date 03/14/01
I selected subject Col & added a Filter Switch to it ... intent of Filter
Switch is to Filter Months by selecting "custom" then "begins with" ... then
enter applicable Month (01, 02, 03, 04, etc).
Issue is ... when I do this the Filtered data shows nothing???
Above said ... I have had this issue before ... so guidance would be welcome
...
Thanks ... Kha
|