i am not sure if i use if statement with the or etc.

cells a1
b2


in cell c2 - if cell a1 has the name "andrew" i want cell c2 to be "monday"
if cell a1 has the name "john" i want cell c2 to be "tuesday"
if cell a1 has the name "george" i want cell c2 to be "wednesday"


thanks

andrewm