Try the below.. Do you mean B2 or B1 ?

=IF(A1<TODAY(),B2,"")


"Tommy" wrote:

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