if function with text

Posted by nhush PM | on Sat, 07/07/2012 - 07:28 413 2 comments | report

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.

paulwakefield1 | Sat, 07/07/2012 - 10:02

sarahf | Sun, 08/07/2012 - 11:52