How to calculate "Age of Asset" & "Monthly Repayment"‏

Hi,

I have a query, how to calculate the Age of Asset & Monthly Repayment (column highlighted in yellow) based on the data given in the attached excel spreadsheet. My email: [email protected]

Thanks

hi yjohari,

type in e11 =TODAY()-C11 and drag it down

you will get the date diffferent from the purchase....

can you please let me know what you want for monthly repayment

hi yjohari,

if you want the age in years please type in e11 =DATEDIF(C11,TODAY(),"y") and drag it down

if you want totall months =DATEDIF(C11,TODAY(),"m")

if you want age in year and month and date, please paste below formula in e11 and drag it down...

="Age is "&DATEDIF(C11,TODAY(),"y")&" Years, "&DATEDIF(C11,TODAY(),"ym")&" Months and "&DATEDIF(C11,TODAY(),"md")&" Days"

Monthly repayment for each asset type.

How to calculate the monthly repayment for each asset type ?