Hi

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

Hope this helps.
Andy.

"Richard" wrote in message
...
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!!!