Help with Anniversary Date In Excel

oo7juk 13:33 14 Oct 08
Locked

In cell B10 I have a date of birth. I am trying to work out what date an individuals 16th birthday would fall on.

I have the following formula in cell C10:

=DATE(YEAR(B10)+16,MONTH(B10),DAY(10))

but I'm not sure if this takes leap years into account.

e.g B10 contains 14/01/1993 and C10 displays 10/01/2009

Should C10 display 14/01/2009?

Many thanks,

Picklefactory 13:41 14 Oct 08

I'm confused.
What have leap years got to do with it. Doesn't your birthday always fall on the same date as your date of birth? Mine does, same date every year, monotonously. :-)
Do you mean what DAY their birthday falls on?

T I M B O 13:43 14 Oct 08

I think 007juk must have meant what day as apposed to what date

Picklefactory 13:47 14 Oct 08

Hmmm I've just re-read and it seems OP's issue is his calculation is not giving correct date. I just used that same formula and it works fine, so not sure why it is not working for them.

VoG II 14:02 14 Oct 08

With the Analysis Toolpack installed (Tools > Addins)

=EDATE(B10,192)

jaraba 14:36 14 Oct 08

=DATE(YEAR(B9)+16,1,14)

Then format cells to show day as well as date.

Format/cells/custom/ddd dd-mm-yy

jaraba 14:38 14 Oct 08

Sorry should say B10 for year & NOT B9

jaraba 14:42 14 Oct 08

Correct:-
=DATE(YEAR(B10)+16,MONTH(B10),DAY(B10))

It is a wed according to this formula.

Picklefactory 15:08 14 Oct 08

That, I think is the answer OP was looking for. His original post stated that he wasn't getting the correct DATE displayed 14/01/1993 going in 10/01/2009 as result. His original formula had the error you have pointed out, on repeating his formula, I also got the same result, your correction puts this right. I think it was as simple as that.

oo7juk 21:59 15 Oct 08

Thanks to all who replied. I didn't even notice my mistake, thanks again for all your prompt replies.

This thread is now locked and can not be replied to.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This stop-frame animation tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…