Date Formula to only show data with dates from 01/01/2022

Occasional Visitor

I got a huge data sheet from SQL but I only want to show those rows that were created since 1st January 2022 (UK date 01/01/2022), what formula or conditional formatting can i use if i make the data refreshable?



1 Reply


Take a look at the relatively new FILTER function. Here's a YouTube video that explains it. As I understand your situation, this would be perfect. Set whatever criteria you want for those derivative spreadsheets, and FILTER will deliver the relevant rows from your master database. (You will need a new version of Excel)