Hi Mike

Supposing your date in B1 and the value you are testing is in A1.
Assuming want to add say 5 days for R, 3 days for L or 7 days for C
=B1+5*(A1="R")+3*(A1="L")+7*(A1="C")

--
Regards

Roger Govier


"MikeL" wrote in message
...
I would like to write a formula that looks at one cell and sees if
there is a
certain letter, R, L or C. and depending on what letter is there it
would add
so many days to another date. I am sure I did it before but I do not
remember how I did it. Can anyone help?