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