Monthly DeprecationFormula

[therookie88]

I'm trying to get a formula for current deprecation that depreciates monthly but I cant seem to figure it out I have it depreciating yearly at the moment. Can anyone see on my formula that I can tweak?

=IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0,[Acquisition Year]<DATE(2016,1,1)),IF(DATEDIF([Acquisition Year],DATE(2016,1,1),"m")<Life*12,[Acquisition Cost]/Life,IF(DATEDIF([Acquisition Year],DATE(2016,1,1),"m")=Life*12,[Acquisition Cost]/Life/2,0)),IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0),[Acquisition Cost]/Life/2,0))

 

[therookie88]

I'm trying to get a formula for current deprecation that depreciates monthly but I cant seem to figure it out I have it depreciating yearly at the moment. Can anyone see on my formula that I can tweak?
=IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0,[Acquisition Year]<DATE(2016,1,1)),IF(DATEDIF([Acquisition Year],DATE(2016,1,1),"m")<Life*12,[Acquisition Cost]/Life,IF(DATEDIF([Acquisition Year],DATE(2016,1,1),"m")=Life*12,[Acquisition Cost]/Life/2,0)),IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0),[Acquisition Cost]/Life/2,0))

 

[therookie88]

=IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0,[Acquisition Year]<DATE(2016,1,1)),IF(DATEDIF([Acquisition Year],DATE(2016,1,1),"m")<Life*12,[Acquisition Cost]/Life,IF(DATEDIF([Acquisition Year],DATE(2016,1,1),"m")=Life*12,[Acquisition Cost]/Life/2,0)),IF(AND(Life>0,LEN(Life)>0,[Acquisition Cost]>0),[Acquisition Cost]/Life/2,0))

I'm trying to get a formula for current deprecation that depreciates monthly but I cant seem to figure it out I have it depreciating yearly at the moment. Can anyone see on my formula that I can tweak?

 

[shg]

Divide by 12?

 

[Mackers]

Are you doing simple interpolation? You can do something of this general form if so (calculates total complete months then multiplies by yearly rate/12):

=DATEDIF(StartDate,EndDate,"m")*YearlyDeprecationRate/12

If not please post some example data and desired outputs so we can try to help you.