Advanced Filter with Date Criterion Range

[BlueRhinos]

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?

 

[lenze]

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]

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!!