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

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.
 

Some videos you may like

This Week's Hot Topics

Top