What about applying the mid-month convention to the formula? If the asset is purchased between 1 - 15, a full month of depreciation is calculated, if purchased from 16 - EOM, then only 50% of depreciation is expensed in the first month. Please advise. Thank you.


Quote Originally Posted by Suhail View Post
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