Set current year with specific date

[Lenzie (Len Paripanapong)]

How can I set current year with specific date of past years in column? Or are there formulas to match this?
I tried to customize and choose “Show Current Year” but it works for current date only.
For example: I would like to let 01/03/2019 in DOB column show 01/03/2023 in Birthday notification column.

It would be much appreciated if you could help me.

Thank you so much

[BiancaT (Bianca Taylor)]

Hey @Lenzie!

Would you following automations better assist you in managing birthday’s each year?

This way each yer the date will be pushed to the following year!

Let me know what you think

[Lenzie (Len Paripanapong)]

Hi BiancaT,

Thank you for your quick reply.
I’ll try it.