date formula

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?
 
S

Sandy Mann

The project requires that when you click on a specific asset

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top