IF function query on Day/Dates

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.

Hi

In A3 enter a date. Then in B3 enter the formula

=CHOOSE(WEEKDAY(A3),"","Maths","Science","Geography","History","","")

This will take the weekday of the date, and select the relevant subject.


HTH

rylo

That worked great man, thanks!