| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ages/date of birth
If I have the age of a person in one cell how do i get their date of birth in
the next cell? Is there a formula? |
|
#2
|
|||
|
|||
|
Assuming you know their birthday this year (in cell A1) and their age this
year (in cell B1), one way is: =IF(A1=TODAY(),DATE(YEAR(A1)-B1,MONTH(A1),DAY(A1)),DATE(YEAR(A1)-B1-1,MONTH(A1),DAY(A1))) Regards Trevor "irishchick28" wrote in message ... If I have the age of a person in one cell how do i get their date of birth in the next cell? Is there a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating age by birth date using excel | Excel Worksheet Functions | |||
| Calculate date of birth in Excel | Excel Worksheet Functions | |||
| What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions | |||
| What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions | |||
Linear Mode
