Advanced Filter Between Two Dates Returns Back Every Record

[GuardianEnzo]

I've been tasked with creating a spreadsheet that will extract Records between two dates. I've been trying to use the Advanced Filter. I figured I could record the Macro and the copy that into a button so that the user can change the two dates, hit the button and update the report.

In the "Expenses" Tab there are 18 Column Headers (A:R)
The Transaction Dates are located in column F

I've created a new tab called "Expense Report"
I activate the advanced filter, and select Expenses!A1:R999 as the list range
The criteria is on the Expenses tab E1:F2 (Start/End | StartDate/EndDate)

I have the dates formatted as mm/dd/yy on both reports, but whenever I run the filter it returns every single item instead of ones between the listed dates.

Any help would be greatly appreciated! Been racking my brain on this one for a couple days now.

 

[pgc01]

The way you decribe, things look OK, but ...

I have the dates formatted as mm/dd/yy on both reports, ....

Excel doesn't care about your formats. Excel will look at the values in the cells, not at the way you format them.

1 - Please check in your source table what's the type of your data source values in column F

Use =ISTEXT() to see if it's a text value and =ISNUMBER() to see if it's a date value


2 - post what you have in the criteria range in E1:F2 (both headers and formulas)