IF and OR Functions Using a Date

Closed
lisa Boland - Aug 29, 2017 at 02:19 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 30, 2017 at 07:55 AM
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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 30, 2017 at 07:55 AM
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
0