D
Dan
Have the following equation:
{=IF(($E40:$E50<TODAY())*($E40:$E50>TODAY()-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.
{=IF(($E40:$E50<TODAY())*($E40:$E50>TODAY()-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.