auto filter with dates

La1988

New Member
Joined
Oct 10, 2014
Messages
2
I am trying to auto filter columns with dates and it doesn't give me a date option for filtering, only text.


Thanks,


Mike
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

La1988

New Member
Joined
Oct 10, 2014
Messages
2
The file is a report run from another program and it appears it is creating the file in Excel 97-03. Could this be the reason the filtering is not working properly? If so, what can I do to fix the issue?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,329
Messages
5,528,033
Members
409,799
Latest member
mlewan_ca

This Week's Hot Topics

Top