I need to calculate with a formula the date of someones next birthday based upon a pre-determined date. For example, I need to calculate the date of a person's birthday based upon a start date at work:

Start Date - 12/2/1999
Birth Date - 08/01/1956
Formula Result - 08/01/2000 because that would be the next birthday for this individual based upon the start date of 12/2/1999.

I simply cannot figure out how to do this with a formula - can anyone help? I'm using Excel 2010 in Window's 7.

Thanks,
Robert G

On Wed, 27 Jun 2012 22:28:29 +0000, Robert G wrote:


I need to calculate with a formula the date of someones next birthday
based upon a pre-determined date. For example, I need to calculate the
date of a person's birthday based upon a start date at work:

Start Date - 12/2/1999
Birth Date - 08/01/1956
Formula Result - 08/01/2000 because that would be the next birthday for
this individual based upon the start date of 12/2/1999.

I simply cannot figure out how to do this with a formula - can anyone
help? I'm using Excel 2010 in Window's 7.

Thanks,
Robert G


=DATE(YEAR(Start_Date)+(Start_DateDATE(YEAR(Start _Date),
MONTH(Birth_Date),DAY(Birth_Date))),MONTH(Birth_Da te),DAY(Birth_Date))

If the two dates above are in cells B1 & B2, enter the below formula in cell B3

=DATE(YEAR(B1)+1,MONTH(B2),DAY(B2))

Is that what you mean?

On Thu, 28 Jun 2012 06:38:11 +0000, Spencer101 wrote:

If the two dates above are in cells B1 & B2, enter the below formula in
cell B3

=DATE(YEAR(B1)+1,MONTH(B2),DAY(B2))

I thought he wanted the *FIRST* birthday after the Start Date.

Ron - thank you so much. Your formula does everything I had hoped, including recognizing that the start date may fall before or after the month and day of the birthdate and adjusts accordingly.

On Thu, 28 Jun 2012 12:43:24 +0000, Robert G wrote:

Ron - thank you so much. Your formula does everything I had hoped,
including recognizing that the start date may fall before or after the
month and day of the birthdate and adjusts accordingly.

Glad to help. Thanks for the feedback.