Thread: Calculating Age
View Single Post
  #1   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default Calculating Age

On Wed, 19 Oct 2005 22:43:42 -0600, "Fred Smith" wrote:

You're better off using:

=year(today())-year(a1)

This will work next year, whereas a hard-coded 2005 will not.


Correction to my previous -- I think horse's birthdays being on 1 Jan only
applies to the northern hemisphere. I believe they are born on a different
date in the southern hemisphere (? 1 Aug or 1 Jul)


--ron