macone1976
asked on
Adjust formula based on date
Hello, I received this formula which works perfectily, but looking to modify it to show data only if the date is past today's date, not within 90 days like the formula below does.
=IFERROR(INDEX(Sheet4!D$2: D$250,SMAL L(IF(Sheet 4!$E$2:$E$ 250>=TODAY (),IF(Shee t4!$E$2:$E $250<=TODA Y()+90,ROW (Sheet4!$E $2:$E$250) -ROW(Sheet 4!$E$2)+1) ),ROWS(A$4 :A4))),"")
=IFERROR(INDEX(Sheet4!D$2:
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER