I'm trying to figure out a function that converts number of days into number of months.
I attached the sample. I didn't get to the number of months just the number of days. I want the result to be as exact as possible.
I first thought of averaging 365 days and the 12 months and use the value output as denominator for the number days. There might be another way but I don't know what it is.
The data is only for date range for 2014, but the data can be (for example) from 03-01-2012 to 06-20-2014.
Thank you.
Bookmarks