Thanks!!!!! That worked perfectly!!

TDawg1831

"pinmaster" wrote:

>
> Hi,
> I'm not sure if this is what your looking for but try this:
>
> =IF(A1="y",IF(DATEDIF(B1,TODAY(),"d")<=C1*365.24,B1+C1*365.24,B1+(2*(C1*365.24))),"")
>
> B1 - effective date
> C1 - term in years
>
> Hope this helps
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=482987
>
>