Filter Table Data Formula, Date Range

[NP71]

Hello,

I am learning how to use formulas to filter data from a table.

I have this formula and need some assistance updating it so that if B2 and/or D2 (date range) is blank, instead of showing nothing, it would gather the last 180 days of data from the table.

=IF(C1="","",FILTER(TData,IF(C1="All",1,TData[EMPLOYEE NAME]=C1)*(TData[AUDIT DATE]>=B2)*(TData[AUDIT DATE]<=D2)*IF(F1="All",1,TData[SHIFT]=F1)*IF(F2="All",1,TData[TYPE]=F2)))

If this is possible, I appreciate any help with this.

Thank you,
Nick

 

[Fluff]

Hi & welcome to MrExcel.

Can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.