Advanced Filter with Date Criterion Range

BlueRhinos

Board Regular
Joined
Aug 31, 2007
Messages
83
I"m trying to create a criteria range for an Excel advanced filter that uses a date combined with an > = operator. is there a way to use a >= operator in front of the formula that derives the date?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Your Criteia Range would look like this
Date
=">="&E1
Where E1 has the date. It might also be something like
Date
=">="&Today()

HTH
lenze
 

BlueRhinos

Board Regular
Joined
Aug 31, 2007
Messages
83
This worked!! As does all of your advice. Thanks for all your expertise..wish I could pay it back but it seems like you know everything in excel already!!
 

Forum statistics

Threads
1,089,200
Messages
5,406,792
Members
403,106
Latest member
AliO

This Week's Hot Topics

Top