Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need age in future year
I'm a new user and need help. I have a column with dates of birth (xx/xx/xx)
and want to know the age (in years only) that each person will be by the end of 2010. Then I want to indicate "yes" if they will be 65 or older by that time. Thanks! -- MEJ |
#2
|
|||
|
|||
Put the measurement in a cell (i'll use D1)
Put the DOB in Cells D2 and below To calculate the age of the person on line 2, enter the formula D$1-D2 in Cell E2 Format Cell E2 to be Custom and use the masking of YY |
#3
|
|||
|
|||
Put the measurement in a cell (i'll use D1)
Put the DOB in Cells D2 and below To calculate the age of the person on line 2, enter the formula D$1-D2 in Cell E2 Format Cell E2 to be Custom and use the masking of YY |
#4
|
|||
|
|||
Chip Pearson explains =datedif() nicely at his site:
http://www.cpearson.com/excel/datedif.htm =DATEDIF(A1,DATE(2010,12,31),"y") Will work for years. MEJ wrote: I'm a new user and need help. I have a column with dates of birth (xx/xx/xx) and want to know the age (in years only) that each person will be by the end of 2010. Then I want to indicate "yes" if they will be 65 or older by that time. Thanks! -- MEJ -- Dave Peterson |
#5
|
|||
|
|||
It would be easier if you had two date columns, one (col a) mm/dd and the
other (col b) yyyy. In a third column (col c), enter =2010-b2. In the fourth column (col d), enter =IF(C164,"YES",""). Drag the formulas down to the end of the data. You may have to format the C column as a number (no decimals). Hope this helps, Carole O "MEJ" wrote: I'm a new user and need help. I have a column with dates of birth (xx/xx/xx) and want to know the age (in years only) that each person will be by the end of 2010. Then I want to indicate "yes" if they will be 65 or older by that time. Thanks! -- MEJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Need totals of values that fall within a given year | Excel Worksheet Functions | |||
Weeknum Year by Year Compare | Charts and Charting in Excel | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |