How to filter for Dates prior to Today
Try the below.. Do you mean B2 or B1 ?
=IF(A1TODAY(),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
|