Snasui Excel Forum

Hi dear,

thank you for always solve my problem.now I come with issues how to calculate depreciation by number of days.
I need your help for formula in yellow colour cells.
when calculate current month ,Total month will equal Current+Previous month.,I want also when move to next month amount in previous month will accumulate from current month.

Thank you

Here's an attachment

..

I4=??
Could you please provide the number at cell I4?
And how it would come?

However, the formula at G4 and H4 would be
G4
=EOMONTH(A4,1)-A4+1

H4
=E4*F4*G4/(EDATE(A4,12)-A4)

If both of them are not the right solution, please provide the method how they would come.

Norkaz

thank you