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
|