Date / Day Function

[banatello]

Is there a way to have Excel give the day of the week from the date entered in a different cell ?

I want to enter a date 07/07/2007 in cell A3, then have Excel display Tues. in a different cell.

[arthurbr]

Wasn't that a Saturday?

[NBVC]

Is there a way to have Excel give the day of the week from the date entered in a different cell ?

I want to enter a date 07/07/2007 in cell A3, then have Excel display Tues. in a different cell.

Assuming you want the actual weekday corresponding to your date...ie. Saturday for 07/07/2007, then try:

=TEXT(A3,"ddd")

for the full name, =TEXT(A3,"dddd")

[banatello]

Thanks guys, and the date and day above was just an example.