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.

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
0
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.
0
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
0