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
I would like to know if there is a better formula in Excel for calculating this
Code:
=F2-(MONTH(E2)-MONTH(D2))
I would like to know if there is a better formula in Excel for calculating this