Worked perfectly thank you so much.
Have a great weekend
Joan

"Elkar" wrote:

Let's say your Date of Birth is in cell A1. Try this formula:

=DATE(YEAR(A1)+65,MONTH(A1)+1,1)

HTH,
Elkar


"Joan" wrote:

I am trying to calculate date: 1st of the month following 65th birthday.
Can calculate 65th BDay, Can calculate 1st of the month but cannot get it
combined

Thanks for your help
Joan