=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"ym")& " months")
This will give only the months portion of the between date. It will not convert the years to month though.
Like: 2 years 3 months will = 3 months, not 27 months!
And:
=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"m")& " months")
will give you your 27 months for 2 years and 3 months. Hope this helps. JSW
This message was edited by Joe Was on 2002-04-26 08:40