I need to create a formula here is the situation:

Have to create a depreciation worksheet for our assets. Items are dep over a
7 year period, cells are created for 2002-2003 2003-2004 blah blah.

I need the 2002 cell to have a forumal that will reference the date cell and
decide if the date is between 2002 and 2008 then populate the cell with a
value it pulls from a diffrent cell (this cell calculates the item cost /7)
this as to happen through all the years.

How would you write this formula?

Thanks for the help in advance.

Steve Good
Colstrip Public Schools