How to calculate and return exact number of days in a month based on criterias

[MyStix01]

Hi,

I am creating a spreadsheet for my depreciation schedule and I'm having problems on calculating the depreciation expense base on the number of days in a month.

Depreciation expense is calculated as =Opening WDV*Dep.Rate*(No.of days in the reporting month/365) since i'm calculating and reporting on a per month basis.

Under cell E2 of Sheet 1, I am to change the month on a monthly basis depending on which prior month I am working on. So in this case, I am to calculate expense for the month of Feb 2018. Please note that I need to calculate base on the exact number of days in a month.

Basically I need a formula under column K of Sheet 2 wherein,

1. If I acquire an asset on the same reporting month, and it is a day other than the first day of the month, then my formula in cell column K should be able to calculate base on the remaining days from the date the asset was acquired until the last day of that month. For example, the furniture. the number of days should be from 16/02/2018-28/02/2018.
2. If the asset is being depreciated over the course of the year on a normal basis, then it should just calculate base on the number of days for that month. Ex. Container - 01 Feb 2018 - 28 Feb 2018
3. If an asset is on it's last term, say in here for example, Tel Equipment was acquired on 20/02/2013, and it has a life of 5 years. on Feb 2018, it is supposed to be fully depreciated, thus, the number of days should only be from 01 Feb 2018 to 20 Feb 2018.

I hope this makes sense and I really hope someone could really help.