The formula you're using returns a result that is text, not a number, which makes it very difficult to do any further calculations with it. Besides which, there is no such thing as a standard 'month', so you can't just divide the number of days by a constant and expect a reliable result. That said, you could use the DATEDIF function to express the number of days as calendar months - but only if you have both the starting date and the end date to which the number (2291.07 - which is actually more than 8.6 years) relates.



Since none of the data from your first post spans even one week, it's difficult to understand what it is you're having issues with on that score. Perhaps you should attach a workbook to a post with some representative data. You can do that via the paperclip symbol on the Advanced posting menu.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]