View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
tisaman tisaman is offline
external usenet poster
 
Posts: 9
Default 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