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