one way
in another cell say b1 =if(a1="R",1,if(a1="L",2,3))
in another cell have =another date+B1
--
paul
remove nospam for email addy!



"MikeL" wrote:

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?