Date from DOB with Current Year

[Peter Davison]

I have a date of birth in Cell B2 (4th June 1956) in a date format.
In the cell below B3 I wanted a formula that would pick the day and month from B2 and the current year so I would end up with 4th June 2023 in a date format.
This is so I can get the number of days between the two cells.
I've tried a number of options without success.
Any help would be appreciated

 

[RoryA]

=DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))

Not sure what you'd want to happen if the DOB were 29th Feb and the current year is not a leap year.

 

[Peter Davison]

Thank you for your help. Good point made. I'll have a think about that one.