Birthday App Sheet

[Anzhelika]

Hi guys. Tell me how best to make a formula for calculating the birthday this year. I have a birthday date and I just want to display it in a calendar. I tried writing date(right([Birthday],4))&"/"&YEAR(today()) but it doesn't work

[Suvrutt_Gurjar · Accepted solution]

Please try 

EOMONTH([Birthday],(YEAR(TODAY())-YEAR([Birthday]))*12-1)+DAY([Birthday])

Edit: There was an incorrect column name from the test expression in the highlighted part of the expression above, that I have corrected.