Search code examples
excelif-statementmaxifs

EDATE, MAXIF Leap Year for last year calc

For this example, The max date in column D is 2/28/2021. I'm trying to return the EOM value for the prior year which would be 2/29/2020 but instead this is returning 2/28/2020. What do I need to change for it to capture the leap year and always bring the last day of the month?

=EDATE(MAXIFS(D:D,H:H,12),-12)
Solution

  • I realized my error. I needed to EOMONTH instead of EDATE