View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Helbron
 
Posts: n/a
Default Formula for Date Calculation

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?

Bill