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)
Aucun commentaire:
Enregistrer un commentaire