Thanks for the clarification. If your sheet is set up as described in your
original post, with the financial year (assuming Jan-Dec) for which you want
to calculate the annual depreciation chargable for in the rows of Column A,
then the following formula should do it for you ...

=IF($E<$A,SLN($F,$I,$G),SLN($F,$I,$G)/12*IF($D>15,12-$C,12-$C+1))

Assumes also that Column G (useful life) is in years. Using the mid-month
straight-line-depreciation method and NOT taking into account the possibility
of any disposals during the year - which you may want to consider (or not!).

HTH, Sean.

"tr2yhb@yahoo.com" wrote:

> I am trying to calculate depreciation chargable in a given financial
> year for an asset that is purchased as some point during that same
> year.
>
>