Adding number of months
Hi,
Try this
=DOLLARFR(DOLLARDE(A1,12)+DOLLARDE(A2,12),12)
Requires the analysis toolpak loaded from Tools|Addins
Mike
"aseshadri" wrote:
How do I add up two number of months to get the right number of years. For
e.g. if I have to add up 0.11 years and 0.01 year, which is 12 months that
make a year, I would want to show is as 1.0 year and any thing above that
should show number of months more than a year until the next 12 months.
|