If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to filter for Dates prior to Today
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|