Age formula

[Hwatsonnn]

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!

 

[DanteAmor]

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]

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]

I'm glad to help you. Thanks for the feedback.