date formula

  • Thread starter Thread starter Maxine
  • Start date Start date
M

Maxine

In a formula relative to straight line depreciation, I have to cells I need
to fill in with formulas. The first cell requires the first year of the
total useful life of the asset. The acquisition date is taken from a
vlookup. The first cell would be a year's worth of depreciation less one
month.

The second cell requires the next full year's amount of depreciation.
The project requires that when you click on a specific asset, the column
lists all the years depreciation starting with the first year in the first
cell of the column to the last year.

I know this sounds confusing, but can you help?
 
The project requires that when you click on a specific asset
Click to expand...

Formulas do not know what the activecell, (ie what cell has been clicked),
is so you would need a VBA solution to do what you want.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top