Please Help

I have an Excel Spreadsheet. Row 3 is filled across with dates - (consecutive Dates). Row 4 is for Days of the week.

What I am trying to accomplish is ---

Day of the week in row 4 to calculate based on date in Row 3 directly above it


Example

C3 = 3/16/04
C4 = Tue

Is this possible? We are tracking 100 days of data at a time and big pain to hand enter all those days of the week.

Perplexed

Give this a go:

=TEXT(C3,"dddd")

Hope that helps,

Smitty

Thanks a bunch. This worked

Perplexed