IF statements with dates and criteria [Solved]

Ask a question jimbabama 2Posts Monday November 7, 2016Registration date November 7, 2016 Last seen - Last answered on Nov 8, 2016 at 06:00 AM by Mazzaropi
Hello,
I needs assistance with "If "statements and criteria within the statement .

Column A has a set of start dates
Column B has a set of End dates
Column C has the If statements with criteria resulting in a date.

So here is what I'm trying to create:
IF A= B then the result in C is the B date, but if A is not = B, then result in C is B date +14 more days.

I have read many examples and can seem to be able to put all of this into one If statement.

Any help is greatly appreciated.

Thank you.
+0
jimbabama, Good evening.

Try to use:

C1 --> =IF(A1=B1, B1, B1+14)

Format A, B and C cells as DATE

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
jimbabama 2Posts Monday November 7, 2016Registration date November 7, 2016 Last seen -
Thank you very much Mazzaropi. This has solved my logic. You made it so simple! Thank you again for answering this question.
+0
Thanks for the feedback.