Morrigan Wrote:
Try this

I3 = DATE(YEAR(G3)+QUOTIENT(H3,12),MONTH(G3)+MOD(H3,12) ,DAY(G3))
J3 = VALUE(I3)-VALUE(F3)



Hmm....forgot to account for last day of the month.

What do you want to show if you sign the contract on Jan 31 and
duration is 1 month. Is expiration date going to be Feb 30 or March 1
or something else?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=537229