Calculating remaining life of Asset in Months

[howard]

I have the start date if D2 and the current month is in F2. The Life of the asset is in G3. I have used the following formula to determine the remaining life

=F2-(MONTH(E2)-MONTH(D2))

I would like to know if there is a better formula in Excel for calculating this

 

[shg]

=assetLifeInMonths - datedif(startDate, asOfDate, "m")

 

[howard]

Thanks for the help. Kindly show me an example of how I can apply this formula

 

[shg]

Kindly show an example of your data.

 

[howard]

See sample Data below

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L
1	Asset Type	Asset Number	Description	Start Date	Current Date	No of Months Dep	Remaining Life	Month to dep	Capital Cost	Current Month Dep	Dep-Year	NBV
2	Office Equipment	2000	Kyocera NR72114 Printer	01/10/2014	01/10/2014	60	60	12	4500	75	900	3600
Fixed Assets

 

[shg]

=F2 - datedif(D2, E2, "m")

 

[howard]

Thanks for the help, much appreciated. Formula works perfectly

 

[shg]

You're welcome.

 

[NonStopLeo]

@ shg
I am trying to calculate the same i.e remaining life of assets.
I have applied the same formula you suggested in post#6 of this thread, but it is giving answer in exact number. I want to know in fractions. Like 20.01 instead of 20.

can you please help. Thanks for your help in advance.

 

[Sanjeev1976]

In the above example you can use the formula =F2-(E2-D2)/30.43 to get the remaining life in fractions