Autofilter on date fields should refelct the underlying data (rat.

M

mrpb

I have a sheet with a list of dates formatted "ddd dd mm yy". It would be
useful to be able to jump to a particular date using autofilter, but the drop
down box offers the various dates in an order determined by the formatted
version of the date (all Fridays, then Mondays, Saturdays, Sundays,
Thursdays, Tuesdays and Wednesdays). It would be more helpful if the drop
down box looked at the underlying date data and ordered the alternatives
accordingly.
 
M

mrpb

Unfortunately, that then shows all the '01' days first, followed by the '02'
days etc.
Formatting as yyyymmdd ddd would work - but that rather destroys the point
of friendly formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top