Forum Discussion
turan_aghayev
Mar 01, 2023Copper Contributor
How can I calculate anniversary date (10, 20, 30, 40, 50, and etc.) ?
Patrick2788
Mar 01, 2023Silver Contributor
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)
mathetes
Mar 01, 2023Silver Contributor