Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for if a cell reaches a certain value | Excel Discussion (Misc queries) | |||
Automaticall e-mail me when cell value reaches a value | Excel Worksheet Functions | |||
Is there a way to make a time cell not reset when it reaches 24? | Excel Discussion (Misc queries) | |||
Highlight Cell when value reaches every interval of 500 | Excel Discussion (Misc queries) | |||
HELP ME !! PLEASE!! How do I highlight a cell when it reaches a va | Excel Worksheet Functions |