if function with text

 

I want to create the following formula, but it doesn't work.

=IF(B5=MONDAY,"12-17",IF(B5=WEDNESDAY,"12-18"))

12-17 AND 12-18 ARE DATES.

is it possible to do it another way?

Comments
There are 2 comments. Login or register to view them.

Assuming

paulwakefield1 |

Missing an argument

sarahf |