IF Formula take 3
 

Sorry for not explaining the problem better.

With the formula =INT((TODAY()-D10)/365.25);
I get a value of "0" for the first year past todays date, and I can only
have a max value of 4.

IF Formula take 3
 

So, what is your problem? Do you want 1 to be returned for the first
year? If so, add 1 to your formula. If you want to ensure that a
number larger than 4 cannot be returned if D10 is many years in the
past, then use this:

=MIN(INT((TODAY()-D10)/365.25)+1,4)

Hope this helps.

Pete


On Nov 8, 7:35 pm, Matt wrote:
Sorry for not explaining the problem better.

With the formula =INT((TODAY()-D10)/365.25);
I get a value of "0" for the first year past todays date, and I can only
have a max value of 4.

IF Formula take 3
 

<Hope this helps

And if it doesn't, please post again *In this thread*, don't start another one

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pete_UK" wrote in message ups.com...
| So, what is your problem? Do you want 1 to be returned for the first
| year? If so, add 1 to your formula. If you want to ensure that a
| number larger than 4 cannot be returned if D10 is many years in the
| past, then use this:
|
| =MIN(INT((TODAY()-D10)/365.25)+1,4)
|
| Hope this helps.
|
| Pete
|
|
| On Nov 8, 7:35 pm, Matt wrote:
| Sorry for not explaining the problem better.
|
| With the formula =INT((TODAY()-D10)/365.25);
| I get a value of "0" for the first year past todays date, and I can only
| have a max value of 4.
|
|