Forum Discussion
I need a IFS statement for it to compare dates. If A2 less than 1 year then X If a2 more than 1 yea
need a statement that will look at a cell and determine the following less then 1 yr then put a 1 more than 1 less then 3 put a 2 more than 3 less then 4 put a 3 more than 4 less then 5 put a ...
I think what you're looking for is something like this:
=MIN(ROUNDUP(DAYS(end_date,start_date)/365,0),8)
It's not linear, both for 1+ and 2+ it shall return 2
