View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan
 
Posts: n/a
Default 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.