Dear Frank Kabel,

I really appreciate the help given. However, your formula didn't help out
the way i hoped it to be.. It only gave me the right end date for durations
of 0 and 1. if the duration is 2 and above, ot would give me an error..

However, i really appreciated the help given in this community workgroup! i
really learnt a lot from the posts!

In fact, i have just learnt about the "sign" and "indirect" functions after
reading your post!

thanks a lot!