IF and OR Functions Using a Date [Closed]

Report
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello,

I am trying to make a formula that says
IF Cell is dateA then the answer is Blue If cell is dateB then answer is Green

If A9=(2017,9,9),"Blue" but adding the second A9=(2017,9,10),"Green" is where I keep losing the formula

Thank you

1 reply

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Lisa Boland, Good morning.

Try to use:

=IF(A9=DATE(2017,9,9),"Blue",IF(A9=DATE(2017,9,10),"Green",""))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão