Projected Depreciation in Excel

[Suhail]

Hi Excel Fox

This formula is working wonderfully. But I stuck in another problem. When I change day in purchase date and put any other day other than 1 day of the month, the formula does not depreciate the last month and there appears book value of last month which should be ZERO.

In the attached sheet, I have changed the purchase dated from 01-Aug-12 to 02-Aug-12, notice that in CELL AM2, the book value of last month is still appearing. Please resolve.

Can we set below criteria:

1. If purchase date appears between 1 to 15 days, the depreciation should be start with same month. For example if we purchase an assets between 1st Aug to 15 Aug then depreciation starts from Aug other wise it should be start from next month i.e. Sep


Regards


Sohail