Date Functions
 

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 Functions
 

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?

Date Functions
 

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.

Date Functions
 

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.