How to calculate values related to specific dates

Originally Posted by JohnTopley

Try

in "Straightline"

=IF(OR(K$4 < EOMONTH($E6,-1)+1,K$4 > EOMONTH($E6+ROUNDUP($G6*365,1),-1)+1),"",IF(K$4=EOMONTH($E6,-1)+1,$D6*$H6*((((EOMONTH(K$4,0))-$E6))/365),IF(K$4=EOMONTH($E6+ROUNDUP($G6*365,1),-1)+1,$I6-SUM($J6:J6),$D6*$H6*(((EOMONTH(K$4,0))-((EOMONTH(K$4,-1)+1))+1)/365))))

in "Diminishing"

=IF(OR(K$4 < EOMONTH($E7,-1)+1,K$4 > EOMONTH($E7+ROUNDUP($G7*365,1),-1)+1),"",IF(K$4=EOMONTH($E7,-1)+1,($AD7-SUM($J7:J7))*$H7*((((EOMONTH(K$4,0))-$E7))/365),IF(K$4=EOMONTH($E7+ROUNDUP($G7*365,1),-1)+1,$AD7-SUM($J7:J7),($AD7-SUM($J7:J7))*$H7*(((EOMONTH(K$4,0))-((EOMONTH(K$4,-1)+1))+1)/365))))

Yey, this now works and everything now reconciles with my testing spreadsheet! I'm so happy!!! Can't believe that this is possible.
Just another thing though, under Sheet 1, the formula for Accumulated Depreciation, I know that it is just taking the total amount for the year i.e Jul-Jun. Can we make it like for example, If I enter the Feb amount, the accumulated depreciation that would reflect in Summary sheet would be -

=(Acquisition Cost/Opening WDV) - whichever has an amount LESS (Sum of Depreciation from July to (whichever month is in cell E2 of Sheet1))

Reason behind is, so that the Summary table will only give me the amounts for the month even though Sheet 2 and 3 is calculating expenses already for the whole year. I hope it makes sense.

Again thank you so much, you're so great!!!! Have a blessed day ahead!