Way to calculate last time a specific date occurred? example given

My study is looking at children's responses in forensic interviews when they are asked to describe what happened on their last birthday.

I have a date of birth column and a date of interview column. I've had RAs fill it in by hand but it is a large file so this sin't ideal.

So, if their date of birth is 8/3/2006 and they were interviewed on 3/21/2013... their last birthday would have been 8/3/2012.

Is there a quick way to calculate the date of their last birthday and input this in a column?

I have only been able to find a formula for calculating days since last birthday (which is useful but not exactly what I need).

Thanks in advance!

=AGGREGATE(14,6,DATE(ROW(INDEX(A:A,YEAR(A1)):INDEX(A:A,YEAR(B1))),MONTH(A1),DAY(A1))/(DATE(ROW(INDEX(A:A,YEAR(A1)):INDEX(A:A,YEAR(B1))),MONTH(A1),DAY(A1))<=B1),1)
a1- date of birth
b1- interview date

Thought I replied! Sorry. Thank you so much this was so helpful and I still use it