View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Calculate horses age as at 1 August

"minigg" wrote:
In Australia all horses age a year on 1st August so if the horse
was born on Feb 2nd, 2012 on 1st August 2012 it will be one year
old


Incredible!

So what would a horse's age be on 1 Aug 2012 if it was born in July 2012: 1
year old?!

And what would a horse's age be on 31 July 2013 if it was born in Sep 2012:
0 years old?!

Looking at http://www.melbournetrackreport.com/...australia.html, I
do see that it says: "Australian horses have their official birthday on
August 1st".

But it does not say __which__ Aug 1st. I can imagine that the date of birth
is the "closest" Aug 1st, with a rule to handle exactly between two firsts
of Aug in leap years.