Help with formula?

[Guest]

I have this formula in cell B17, which is hire
date(=DATEDIF(B16,TODAY(),"Y")&" years, "&DATEDIF(B16,TODAY(),"YM")&" months
"&DATEDIF(B16,TODAY(),"MD")&" days" ) In B3 I need to show either a 3 or 4, 3
if less than 5 years 4 if >= 5 years. Thanks in advance!!!

 

[Guest]

Hi

Try this:
=IF(DATEDIF(B16,TODAY(),"Y")<5,3,4)

Hope this helps.
Andy.