Formula went in to invalid operation when updating date range

Kyle Black

Not sure what i accidently changed. please help i am not seeing my mistake.

=COUNTIFS({Behavior Based Safety Observation Range 1}, IFERROR((@cell), 0), >=DATE(2022, 1, 1), {Behavior Based Safety Observation Range 1}, IFERROR((@cell), 0), <=DATE(2022, 1, 31), {Behavior Based Safety Observation Range 3}, "approved")

Garrett Henke

@Kyle Black Check the source sheet to see if you have a row with the approved status but the date is blank. I have had similar issues in the past where one of the criteria is missing thus causing the invalid error.

Garrett Henke

@Kyle Black Check the source sheet to see if you have a row with the approved status but the date is blank. I have had similar issues in the past where one of the criteria is missing thus causing the invalid error.

Kyle Black

Thank you some knucklehead put /// for the date and screwed it all up.