Forum Discussion
Solved
Date range search and marking if theres a value
I am looking for the correct excel formula for the following problem: - in the corresponding cell - marked in yellow in the image - you should mark with an x if there is a value in the given row (le...
The formula for the AO column must look like this!
=IF(COUNTIFS(3:3,">="&AO$6,3:3,"<="&AO$5,7:7,"I")>0,"x","")See also my enclosed example.
The prerequisite is that the cells in row 3 are correct dates.
