Formula for calculating the date a person will be a certain date from their date of birth

**zander165** · 11-03-2014, 09:01 AM

Hi All,

I wonder if anyone can help me.

I am a cub scout leader and I am currently trying to put together a list of dates that my cubs will turn 10- 1/2 which is the age that they can move up to scouts.

Is there a formula that can can calcualte this from the individuals DOB. Basically I need to add 126 months onto the DOB. Now I know that I could do this manually but I have 45 to do and wanted to automate if possible.

Thanks in advance

**martindwilson** · 11-03-2014, 09:31 AM

to add 126 months
=EDATE(A1,126)
where a1 is dob
as you have excel 2003 you may have to make sure the analysis tool pak add in is activatad
http://office.microsoft.com/en-gb/ex...001127724.aspx

**6StringJazzer** · 11-03-2014, 10:29 AM

A formula that will do this without add-ins is

=DATE(YEAR(A1),MONTH(A1)+126),DAY(A1))

Formula for calculating the date a person will be a certain date from their date of birth

LinkBack

Thread Tools

Rate This Thread

Display

Formula for calculating the date a person will be a certain date from their date of birth

Re: Formula for calculating the date a person will be a certain date from their date of bi

Re: Formula for calculating the date a person will be a certain date from their date of bi

Thread Information

Users Browsing this Thread

Similar Threads

Formulas Calculating Age based on Date of Birth & Date of Death

[SOLVED] Using a person's birth date to detect the originality of work performed on a sheet

Calculating ages from date of birth and specific date

Can i find out the Date of Birth of any person

formula to calculate age using birth date and current date

Bookmarks

Bookmarks

Posting Permissions