I want the day of the week when I insert a date

H

HT

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.
 
C

CLR

Right-click on the cell with the date you wish converted to "Weekday" >
Format Cells > NumberTab > Custom > and type dddd in the little window....> ok

Vaya con Dios,
Chuck, CABGx3
 
G

Gary''s Student

If a date is in A1, then in B1 put:

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

Bob Phillips

or =TEXT(A1,"dddd")


--
HTH

Bob Phillips

Gary''s Student said:
If a date is in A1, then in B1 put:

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Frid
ay","Saturday")
Click to expand...
 
H

HT

Thanks guys..another user said to use Format, Cell, Number, Date and click
on the second option that includes the day with the date.
 
Top