Thank you! That works perfectly...one other problem. I want it to stop
rounding the number up or down. I want it to be like this for example:
My 2 dates are 27-Nov-06 19-Nov-08 = 23.78 this is a result from
another system we have. But I'm creating a spreadsheet that we will use
instead so I need it to automatically calculate without rounding.
DATEDIF will not calculate fractions of a month... whole number of months
only. If you think about it, though, 0.78 months is a meaningless measure
because the fraction will depend on the number of days and which months are
spanned by them (45 days across February would produce a different fraction
part of a month than 45 days across July). Besides, what is it 0.78 of? That
0.78 would represent 24.18 days if applied to January, but only 21.84 days
if applied to February.
Rick
