IF statements with dates and criteria

Solved/Closed
jimbabama Posts 2 Registration date Monday November 7, 2016 Status Member Last seen November 7, 2016 - Nov 7, 2016 at 06:20 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 8, 2016 at 06:00 AM
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.
Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 7, 2016 at 06:52 PM
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 Posts 2 Registration date Monday November 7, 2016 Status Member Last seen November 7, 2016
Nov 7, 2016 at 08:10 PM
Thank you very much Mazzaropi. This has solved my logic. You made it so simple! Thank you again for answering this question.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 8, 2016 at 06:00 AM
Thanks for the feedback.

Glad to be of help!
--
Belo Horizonte, Brasil.
Marcílio Lobão