Formula for Date Calculation

Giganews Newsgroups
Subject: Formula for Date Calculation
Posted by:  Bill Helbron (jw.helbr…
Date: Fri, 05 May 2006

I have a spreadsheet that includes a "Birth" and "Death" column and an "Age"
column. Calculating the age is simple but what I want to do is, if the person is
still living, would like to calculate their age as of the current date and
perhaps using a different color. Any suggestions for a formula?