Forum Discussion
Solved
MAXIFS with DATEVALUE
I'm trying to enter the MAXIFS function in E2, but Excel doesn't recognize the formula. Thanks for any help you can offer.
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.
My entire problem is traced back to my mistake in the reference to the range named VisitDate. With that reference correct now, MAXIFS gives correct result for both text to date conversions in LF!P:P and LF!R:R. I wanted to attach a final copy, but maybe there is a limit. Thank you for your help with this
scheij , thank you for the update, glad to help