ExcelBanter - Help with formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with formula? (https://www.excelbanter.com/excel-discussion-misc-queries/103746-help-formula.html)

Richard

Help with formula?

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!!!

Help with formula?

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!!!

All times are GMT +1. The time now is 03:53 PM.