Hi Tony

If I understand you correctly, you want a full month's depreciation in
month of acquisition, but only elapsed time for the final (or current
month).
If that is the case, then with dates in A1 and B1, Asset value in C1 and
Depreciation rate in D1
=(B1-DATE(YEAR(A1),MONTH(A1),0))/365.25*C1*D1

--
Regards

Roger Govier


"Tony" wrote in message
...
I need some help. I am writing a formula to calculate my asset
depreciation
schedule. The rule is, the new purchased asset will be depreciated
for the
full in current month, no matter what date the asset purchased within
the
month, the depreciation will be calculated for full month e.g.
purchase on
29-Nov-06 will depreciate for 30 days in Nov.

I use EOMONTH function, it works in purchase month (refer Purchase
Month
table 1). However, it doesn't work afterward, because EOMONTH
calculated in
days (Refer After Purchase table 1). Then I changed into Month
format. It
works in after purchase period (Refer After Purchase table 2) but then
it
doesn't work in purchase month (Refer Purchase Month 2). I changed
MONTH &
EOMONTH combine, it works in purchase month (Refer Purchase Month
table 3)
but it doesn't work in after purchase (Refer After Purchase table 3).


Purchase Month
A1 B1 Formula Result
1 29-Nov-06 30-Nov-06 =EOMONTH(B1,0)-EOMONTH(A1,0) 0
2 29-Nov-06 30-Nov-06 =month((EOMONTH(B1,0)-EOMONTH(A1,0))) 1
3 29-Nov-06 30-Nov-06 =MONTH(EOMONTH(B1,0))-MONTH(EOMONTH(A1,0)) 0

After Purchase
A1 B1 Formula Result
1 29-Nov-06 30-Jun-07 =EOMONTH(B1,0)-EOMONTH(A1,0) 212
2 29-Nov-06 30-Jun-07 =month((EOMONTH(B1,0)-EOMONTH(A1,0))) 7
3 29-Nov-06 30-Jun-07 =MONTH(EOMONTH(B1,0))-MONTH(EOMONTH(A1,0)) -5