Hi
try
=I28+7+7*(E28="TBG")

--
Regards
Frank Kabel
Frankfurt, Germany
"Connie Martin" schrieb im
Newsbeitrag ...
The formulas you have given are adding too many days (21 and 14) where TBG
is
not in E28:E500.

Perhaps I didn't explain myself well enough. I28 is a date and in M28 I
want a date that's 7 days later than I28, but if E28 says "TBG" then I
want
M28 to add 14 days. If E28 says anything else it's to add only 7 days in
M28.

Connie


"Connie Martin" wrote:

Another simple one, I'm sure. I have this simple formula: =I28+7

I want to add to this that it's to add 14 if "TBG" is found in E28:E500,
otherwise add only 7.

Connie