Forum Discussion
MAXIFS with DATEVALUE
Maybe, I'm not sure which ranges are to be taken. That was only to illustrate that named range causes no error with MAXIFS if only it returns correct data. In our case that shall be dates, not texts as with your variant.
To be sure you may return spill such named range at any place and check with ISTEXT() do you have texts or dates.
The MAXIFS result 05/07/1962 is incorrect because criteria2 (SurvE,$B$3) has only dates in 2022.
The text to date conversion should be on VisitDateText in VisitData!M:M, not FishData!P:P. I have a mistake in the reference for VisitDate.
Maybe, I'm not sure which ranges are to be taken. That was only to illustrate that named range causes no error with MAXIFS if only it returns correct data. In our case that shall be dates, not texts as with your variant.
To be sure you may return spill such named range at any place and check with ISTEXT() do you have texts or dates.