Hi
If i enter dob and age 70 in another cell.
Could someone tell me the formula to find the date they reach age 70 or any age in that cell.
Any help appreciated
Hi
If i enter dob and age 70 in another cell.
Could someone tell me the formula to find the date they reach age 70 or any age in that cell.
Any help appreciated
In A1 enter the DOB
B1 Enter the age 70
n C1 enter the formula below:
Formula:Please Login or Register to view this content.
Last edited by playaller; 05-11-2014 at 06:11 PM.
Shelton A.
If Helpful, Add Reputaion!
try
=DATE(YEAR(DOB)+70,MONTH(DOB),DAY(DOB))
DoB = A1
Age = B1
=DATE(YEAR(DOB)+B1,MONTH(DOB),DAY(DOB))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Also in addition you can use this if you need to know specifically how long before they turn that day
In A1: DOB
In B1: 70
In C1:
Formula:Please Login or Register to view this content.
In D1:
Formula:Please Login or Register to view this content.
If a person was born on a leap day (2/29/1932), would their 70th birthday be 2/28/2002 or 3/1/2002?
Use this formula if you think their 70th birthday should be 2/28/2002:
Data Range
A B C 1 DOB Age Date 2 2/29/1932 70 2/28/2002
=EDATE(A2,B2*12)
Format as Date
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
awesome - many thanks
will add reputation tonight
Thanks guys
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks