Derive day of the week from date

[jaZZerkill]

I need to derive the day of the week from a date I have in excel using a function.

Example:

26/03/2012 --> Monday
29/03/2012 --> Thursday

Anyone know how to do this?

Thx in advance

[Bob Phillips]

Simple as

=CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

or just

=TEXT(A2,"dddd")