Date Functions

[Robert G]

I need to calculate with a formula the date of someones next birthda
based upon a pre-determined date. For example, I need to calculate th
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 fo
this individual based upon the start date of 12/2/1999.

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

Thanks,
Robert

 

[Ron Rosenfeld]

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_Date>DATE(YEAR(Start_Date),
MONTH(Birth_Date),DAY(Birth_Date))),MONTH(Birth_Date),DAY(Birth_Date))

 

[Spencer101]

I need to calculate with a formula the date of someones next birthda
based upon a pre-determined date. For example, I need to calculate th
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 fo
this individual based upon the start date of 12/2/1999.

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

Thanks,
Robert G

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

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

Is that what you mean

 

[Ron Rosenfeld]

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.

 

[Robert G]

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

;1603205']On Wed, 27 Jun 2012 22:28:29 +0000, Robert

I need to calculate with a formula the date of someones next birthday
based upon a pre-determined date. For example, I need to calculat 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 birthda 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_Date>DATE(YEAR(Start_Date),
MONTH(Birth_Date),DAY(Birth_Date))),MONTH(Birth_Date),DAY(Birth_Date)

 

[Ron Rosenfeld]

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.