Hi to all!

I'm having problem getting the IF function to recognize Date or text as a logical test. I like to insert date(or day) in one column and have the results in the 2nd column. Hence, if Cell A2 showed Monday, Cell B2 will show Maths and so on. Here's my weak and amateur attempt.


=IF(A2=Monday,"Maths",IF(A2=Tuesday,"Science", IF(A2=Wednesday,"Geography",IF(A2=Thursday,"History"))))

But I'm unable to achive the results I want. Hope someone can help me out here.