Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

IF statements with dates and criteria [Solved/Closed]

Report
Posts
2
Registration date
Monday November 7, 2016
Status
Member
Last seen
November 7, 2016
 -
Posts
1890
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 3, 2021
 -
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 replies

Answer 1 / 2
Posts
1890
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 3, 2021
 142
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
Report
Posts
2
Registration date
Monday November 7, 2016
Status
Member
Last seen
November 7, 2016
Thank you very much Mazzaropi. This has solved my logic. You made it so simple! Thank you again for answering this question.
Answer 2 / 2
Posts
1890
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 3, 2021
 142
Thanks for the feedback.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!