Calculating When Somebody Reaches a Certain Age
Hi
I have noticed that there are a few posts showing how to calculate somebody's current age by inputting their date of birth. However, what I am after is something slightly different. How can I get excel to calculate when somebody would reach a certain age by their date of birth. For example; I enter a date of birth of 04 May 2009, but I would like Excel to tell me on what date they would reach 16. Yeah, I know I could work the date out in my head quite easily, but it would be very handy to have a formula that would automatically do it for me. Thank you :) |
Calculating When Somebody Reaches a Certain Age
Hi,
=DATE(YEAR(A1)+16,MONTH(A1),DAY(A1)) Mike "Popey" wrote: Hi I have noticed that there are a few posts showing how to calculate somebody's current age by inputting their date of birth. However, what I am after is something slightly different. How can I get excel to calculate when somebody would reach a certain age by their date of birth. For example; I enter a date of birth of 04 May 2009, but I would like Excel to tell me on what date they would reach 16. Yeah, I know I could work the date out in my head quite easily, but it would be very handy to have a formula that would automatically do it for me. Thank you :) |
Calculating When Somebody Reaches a Certain Age
With the date in A1
=DATE(YEAR(A1)+16, MONTH(A1), DAY(A1)) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Popey" wrote in message ... Hi I have noticed that there are a few posts showing how to calculate somebody's current age by inputting their date of birth. However, what I am after is something slightly different. How can I get excel to calculate when somebody would reach a certain age by their date of birth. For example; I enter a date of birth of 04 May 2009, but I would like Excel to tell me on what date they would reach 16. Yeah, I know I could work the date out in my head quite easily, but it would be very handy to have a formula that would automatically do it for me. Thank you :) |
Calculating When Somebody Reaches a Certain Age
With birth date in A1 enter the below formula and format the formula cell to
Date.. =DATE(YEAR(A1)+16, MONTH(A1), DAY(A1)) If this post helps click Yes --------------- Jacob Skaria "Popey" wrote: Hi I have noticed that there are a few posts showing how to calculate somebody's current age by inputting their date of birth. However, what I am after is something slightly different. How can I get excel to calculate when somebody would reach a certain age by their date of birth. For example; I enter a date of birth of 04 May 2009, but I would like Excel to tell me on what date they would reach 16. Yeah, I know I could work the date out in my head quite easily, but it would be very handy to have a formula that would automatically do it for me. Thank you :) |
Calculating When Somebody Reaches a Certain Age
Hi Mike H & Bernard. Thank you both for your replies - the formula works perfectly and is just what I needed. Thanks again. |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com