Given date returning day of the week

Hi - have been trying to ascertain whether this is possible.

I have two rows;

1 = day
2 = date

What I'm trying to do is when I input a date in a cell I want the day cell (located directly above) to be (automatically) populated with the day (shown in text).

I use Excel 2004 for Mac.

Thanks in advance.

Thanks Paul - perfect!