Hi
what exact formula have you used and have you entered this formula as array
formula?

--
Regards
Frank Kabel
Frankfurt, Germany
"kippi3000" schrieb im Newsbeitrag
...
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!