Mar 01 2023 09:50 AM
See the attached file for your answer. It looks like this, using this formula copied from cell C2 to all the others. =DATE(YEAR($B2)+C$1,MONTH($B2),DAY($B2))
Mar 01 2023 10:43 AM
Mar 01 2023 10:53 AM
This may be totally unnecessary but it was fun creating. I put all the dates in the one column because it seems you may have preferred that to multiple columns.
=LAMBDA(birth_days,number_of_anniversaries,BYROW(
birth_days,
LAMBDA(row,
TEXTJOIN(
", ",
,
TEXT(
DATE(YEAR(row) + SEQUENCE(, number_of_anniversaries, 10, 10), MONTH(row), DAY(row)),
"m/d/yyy"
)
)
)
))
The Anniversary function. Provide the birthdays and tell it how many anniversaries you'd like to show:
=Anniversary(bday,5)
Mar 01 2023 11:48 AM