Extract # Days and Months from 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 Months and Days into a formula I am using
How can I extract the Months from the YearsMonthsDays formula and convert that to days?
Lets say that the YearsMonthsDays = 10 months...I would want the 10 months to convert to 10*30 = 300 days but in addition to that I would want to add the number of days that was in the formula. So, if there was 10 months and 10 days then the answer would be 300+10 = 310 days.
If there were Years involved then I would have to strip the years from the conversion to days. I am only interested in Days...not the # days in the year.
I hope this makes sense...please ask if need additional information.