Forum Discussion
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.
10 Replies
- Yes, my version of Excel does support the MAXIFS function. I've used it before.
First parameter shall be the range, not formula. Convert first column into dates first.
Thanks, Sergei. VisitDateText, GearE, and SurvE are named ranges in the VisitData worksheet. Many cells in those named ranges are blank in this workbook. The VisitDate named range in the LF worksheet converts the text to a DATEVALUE. It seems the #VALUE results in VisitDate are causing the MAXIFS function in Q6 to return zero.
