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...

excel

Formulas and Functions

dscheikey
Jun 11, 2024
TomGrey

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.
TomGrey.xlsx9 KB

dscheikey

Bronze Contributor

Jun 11, 2024

TomGrey

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.

TomGrey.xlsx9 KB

TomGrey

Copper Contributor

Jun 13, 2024

dscheikey

Thank you very much, working perfectly with a slight modification to $3$3,. Wonderful you saved me a tremendous amount of time! Thank you very much!

Forum Discussion

Date range search and marking if theres a value

Resources