# Age formula

#### Hwatsonnn

##### New Member
I currently have a formula telling me the the date in which an animal reaches 16 months in age or 30 months in age, depending on whether they are a "B" or an "ST".

=IF(E3="B",EDATE(C3,16),IF(E3="ST",EDATE(C3,30)))

Would it be possible to add a function that would display a dash "-" if the B is over the 16 months of age.

As well as a something that would display "OTM", if the ST's age has gone over 30 months of age.

Help would be much appreciated! Last edited:

#### DanteAmor

##### Well-known Member
Try this:

=IF(E3="B",IF(DATEDIF(C3,TODAY(),"m")>16,"-",EDATE(C3,16)),IF(E3="ST",IF(DATEDIF(C3,TODAY(),"m")>30,"OTM",EDATE(C3,30))))

• Hwatsonnn

#### Hwatsonnn

##### New Member
Try this:

=IF(E3="B",IF(DATEDIF(C3,TODAY(),"m")>16,"-",EDATE(C3,16)),IF(E3="ST",IF(DATEDIF(C3,TODAY(),"m")>30,"OTM",EDATE(C3,30))))
This is perfect thanks, I lowered the 16 to 15 and 30 to 29 to discount animals which are over 16 but less than 17. This will help greatly, thanks again.

• DanteAmor