You guys are awesome, Thanks for the help!

Debsdad

"Rick Rothstein (MVP - VB)" wrote:

Thanks, it worked great! Now that it returned a date I need to have the
next
coloumn add days based on anoter cell so it would be like this: IF F2=date
then add formula from cell J2. Can this be done?

What is in J2... a number of days? Maybe you want something like this...

=IF(F2<"",F2+J2,"")

where I only test for <"" because I assume the formula Peo and I posted is
what is in F2.

Rick