Calculate horses age as at 1 August
On Tue, 26 Feb 2013 22:36:48 +0000, minigg wrote:
I need a worksheet that will allow me to enter a date (for the horse
show) and then my horses birthday to give me the horses' show age.
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 (even
though technically it is only 5 months old it has to show as a
yearling.
Ideas ??
With the DOB in A1, try:
=DATEDIF(DATE(YEAR(A1)-1+(MONTH(A1)7),8,1),TODAY(),"y")
This assumes that a horse born on 8/1/2012 will not be one year old until 8/1/2013. If that is not the case, and a horse born on 8/1/2012 is immediately one year old, then try:
=DATEDIF(DATE(YEAR(A1)-1+(MONTH(A1-1)7),8,1),TODAY(),"y")
|