ExcelBanter - Conditional If statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional If statement (https://www.excelbanter.com/excel-worksheet-functions/79674-conditional-if-statement.html)

Dan

Conditional If statement

Have the following equation:

{=IF(($E40:$E50<TODAY())*($E40:$E50TODAY()-21),$E40:$E50)}

which returns either the date in the cell or "FALSE". I want to modify the
equation to only return the dates in the range of cells. E40:E50 may contain
from 0 to 11 responses that match the criteria.

Your help is appreciated.

All times are GMT +1. The time now is 05:15 AM.