IF Formula take 2

[Guest]

I tried to use all the formulas in the response,but could not get them to work.

This is the formula I used,

=IF(D9>1095,"4",IF(D9>730,"3",IF(D9>365,"2",IF(D9>0,"1"))))

If I enter 2 in D9 cell value will be 1
365 1
366 2
735 3 etc.
With a max of 4 after 1095

It works if you enter a numeric value in D9. I need it to work off of
todays date.

I will be using this for years, I do not need leap year to count unless it
will throw the sheet off during leap year.
I hope this provides enough information.

 

[JE McGimpsey]

I hope this provides enough information.

It doesn't explain what the problem was with the solution I gave, which
is based on the difference between a date and TODAY().

You also don't really address leap year - since you don't specify what
the calculation will be used for, only you can possibly know whether
ignoring leap year will "throw the sheet off".

 

[Guest]

=INT((TODAY()-D10)/365.25)

The max value I can show is 4. Within the first year from todays date
returns a value of 0.

 

[Pete_UK]

See response elsewhere - don't start a new thread on the same topic.

Pete