How to filter for Dates prior to Today

T

Tommy

If I have two columns of information or mutiple columns and column A is the
date an event happened or will happen, how would write a formula to say if
the date (A1) is prior to today, display B2, else nothing/blank? Is it
possible and could I display additional fields well, using the date prior to
current as main filter mechanism?

Thanks,

Tommy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
calculating dates prior to a given date 1
How do count a cell range that include all dates prior to today? 3
Formatting Dates from Text to Numbers 2
Excel High lightng dates in future, today and past 1
filtering dates in a Pivot Table Report Filter 3
Auto Filter 3
Counting Dates 3

Top