Years in decimals convert to date from a specific date (using calendar month not average)

Hi all,

I am really struggling with this.

I have tried EDATE/DATE/YEARFRAC/EOMONTH but cannot get this right as some formulas average out based on 30 days.

Depreciation is calculated by Day
Straight Line Method is used
Depreciation rate 25%
Useful Life 4



Original cost of asset $20,978.80
Acquistion date 22/12/2017
Commission Date 1/12/2018
Total Depreciation charged to 31/12/21 $20,533.29
Useful Life 3.1699
Expired Life (as at 31/12/21) 3.0800




Closing period 31/12/2021
Remaining Life in Years (as at 31/12/21) 0.089900
NBV $445.51


Start Date (To calculate from) 1/01/2022





Questions:
1 What would the end date be - In Years (if calculating from start date 1/1/22)
2 What would the end date be - In Calendar Month (if calculating from start date 1/1/22)
3 What would the end date be - In Days (if calculating from start date 1/1/22)
4 How do I convert remaining years into months if day depreciation is used? I cannot use months here I need calendar months. I also need the fraction/decimal ( (if calculating from start date 1/1/22)



What I do know is this:
Depreciation was charged as follows:
Jan-22 $445.44
Feb-22 $0.07


The acquisition dates/commission dates and due to many adjustments (changed systems) calculations are all over the place. I am just working on trying to clean this up to push into Workday.
I am able to round to 6 decimal places in workday. I am not looking for any rounding here.

Thanks for your response.

As an example if we look at Jan-22/Year 2022.

Number of Days (Jan-22 = 31)/Number of total days in year (2022 = 365) x Total Cost ($20,978.80)/Useful Life (4 Years).

I am trying to calculate the end date based off the remaining useful life (0.089900 years) from 1/1/2022.

The problem is the data in the old system has been changed and does not make sense despite what dates i use. It does not make sense to charge for Jan-22 because technically it should have been fully depreciated as at 31/12/2021. (based on Acquisition date 22/12/17 or commission date 1/12/18). So in a nutshell i am losing my mind of best approach to convert 0.089900 years into periods (calendar months) from 1/1/22 especially because depreciation is calculated daily and i do not have any reports showing deprecation end date.