Calculating Depreciation

[sbironas]

I am trying to figure out dates for my depreciation schedule.
For example, I have an asset with an aquisition date:10/28/99, I need
to depreciate it over 7 years.

I would like some help with calculating the end date for this asset.

So basically 10/28/99 + 7years times 12, to get to an end date..

Can someone please help me.

Much thanks

 

[Chip Pearson]

Use a formula like the following:

=DATE(YEAR(A1)+7,MONTH(A1),DAY(A1))

This will return a date 7 years past the date in A1.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com