Extract # of Years from Date formula
Posted on 2011-02-21
I have this formula:
and it returns X Years, Y Months and Z Days
I need to incorporate the # of Years into a formula I am using
How can I extract the Years from the YearsMonthsDays formula?
Lets say that the YearsMonthsDays = 10 years and 5 months and 10 days...I would want the answer to be 10 only and no fraction of years.
I hope this makes sense...please ask if need additional information.