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

This is the formula I used,

=IF(D91095,"4",IF(D9730,"3",IF(D9365,"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.

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".


In article ,
Matt wrote:

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

This is the formula I used,

=IF(D91095,"4",IF(D9730,"3",IF(D9365,"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.

=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.

"Matt" wrote:

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

This is the formula I used,

=IF(D91095,"4",IF(D9730,"3",IF(D9365,"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.

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

Pete

On Nov 8, 7:23 pm, Matt wrote:
=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.



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

This is the formula I used,

=IF(D91095,"4",IF(D9730,"3",IF(D9365,"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.- Hide quoted text -

- Show quoted text -