Thread: Age Calculation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Age Calculation

=DATEDIF(DATE(2000,12,25),DATE(2006,12,31),"Y")


"Joan V" wrote:

What is the best way to calculate age as of a certain date (as in age of a
person as of 12/31/2006)?