close
Have the following equation:
{=IF(($E40:$E50lt;TODAY())*($E40:$E50gt;TODAY()-21),$E40:$E50)}
which returns either the date in the cell or quot;FALSEquot;. 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.
全站熱搜
留言列表
