Steps to Speed Up Windows 10: How to Fix - Date Filters in Excel 2007 not working?

Monday, September 26, 2016

How to Fix - Date Filters in Excel 2007 not working?

Date Filters in Excel 2007 not working

Hi,
Column E has manually input dates.
Column F has dates computed using a formula.
When Autofilter is applied, Column E shows the Date Filters option, while the Filter in Column F shows Text Filters only.
How can I get Date Filters in Column F.
Incidentally, both Column E and F are formatted as Dates.
Thanks in advance for the help.
Regards,
Rajendra

Keys to the Problem Date Filters in Excel 2007 not working

Download SmartPCFixer for Free Now

Raj sent me the file.
It seems it gives Text Filters when there are more text values ("") than date values in the list.
I deleted rows from the unused area until dates had a majority and then Date Filters was given instead.

3 solutions suggest themselves:
a) clear the additional rows.
- on entering a date at the bottom of column E, the formulas in F should fill down automatically,
(if not, set Office Button > Excel Options > Advanced > Editing options: extend data range formats and formulas)
b) turn the used rows into a Table
- this should always extend the formulas when you add a date in a new row at the bottom of the table
c) change the formula to give 0 for missing dates, and apply the custom format dd-mmm-yy;; (note the 2 semi-colons) to the formula cells.

Bill Manville.
Excel MVP, Oxford, England.
www.manville.org.uk

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Another Safe way to Fix the Problem: Date Filters in Excel 2007 not working:

How to Fix Date Filters in Excel 2007 not working with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The errors will be shown in the list.