Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
value of 2 cells
i have three cells:
one with the date of birth the other with the date of death and in the 3rd cell i would like to get the age between the two other cells which is "the age at time of death". What formula would i use in the 3rd cell to get the age at time of death? thank you so much for your help. tonia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
value of 2 cells
On Apr 8, 3:52*pm, tisaman wrote:
i have three cells: one with the date of birth the other with the date of death and in the 3rd cell i would like to get the age between the two other cells which is "the age at time of death". What formula would i use in the 3rd cell to get the age at time of death? thank you so much for your help. tonia I don't think that you posted your question in the proper forum but .... The quick and dirty way, is this simple formula: =(Death Date - Birth Date)/365.25 *Note: 365.25 is the assumed number of days in a year taking into consideration leap year. -Brian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
value of 2 cells
thank you
i guess i did post to the wrong forum i have reposted in the correct spot thanks brian "Brian B." wrote: On Apr 8, 3:52 pm, tisaman wrote: i have three cells: one with the date of birth the other with the date of death and in the 3rd cell i would like to get the age between the two other cells which is "the age at time of death". What formula would i use in the 3rd cell to get the age at time of death? thank you so much for your help. tonia I don't think that you posted your question in the proper forum but .... The quick and dirty way, is this simple formula: =(Death Date - Birth Date)/365.25 *Note: 365.25 is the assumed number of days in a year taking into consideration leap year. -Brian |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
value of 2 cells
"tisaman" wrote in message
... i have three cells: one with the date of birth the other with the date of death and in the 3rd cell i would like to get the age between the two other cells which is "the age at time of death". What formula would i use in the 3rd cell to get the age at time of death? thank you so much for your help. tonia I think it's... =IF(OR(MONTH(B1)<MONTH(A1),AND(MONTH(B1)=MONTH(A1) ,DAY(B1)<DAY(A1))),YEAR(B1 )-YEAR(A1)-1,YEAR(B1)-YEAR(A1)) where A1 = dob and B1 = dod i.e. age = year of death - year of birth unless 1. the month of death was less then the month of birth OR 2. the months were the same AND the day of death was less than the day of birth in which case you subtract 1 from the age -- roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming |