Is there an excel function that takes the date from another cell and returns the day of the week? Or am I forced to use macros?

EDIT: Using Office 2002.

EDIT2: if it's not possible in excel but possible in open office, I'll be finally convinced to switch.

[ 03-28-2007, 04:45 AM: Message edited by: ZFR ]

Thank you. That's just what I needed.