How to filter for Dates prior to Today

  • Thread starter Thread starter Tommy
  • Start date Start date
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
 
Back
Top