Report

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 06:00AM
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.
See more 
Helpful
+0
moins plus
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 - Nov 7, 2016 08:10PM
Thank you very much Mazzaropi. This has solved my logic. You made it so simple! Thank you again for answering this question.
Reply
Add comment
Helpful
+0
moins plus
Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!