how to insert day of the week

[Sachi Noma]

I use win xp home edition, sp2, excel 2003

Can someone tell me how I can insert day of the week next to my date,
example May 18, 2006 Thurs

 

[Paul Lautman]

I use win xp home edition, sp2, excel 2003

Can someone tell me how I can insert day of the week next to my date,
example May 18, 2006 Thurs

TEXT(NOW(),"ddd")

 

[Dave Peterson]

You can apply a custom format and have the date/day in the same cell:

format|Cells|number tab|custom category:

mmm dd, yyyy ddd
for 3 character day

mmm dd, yyyy dddd
for the complete spelling of the day



Or with the date in A1, you could use an additional cell:
=a1
and format as ddd or dddd

or
=text(a1,"ddd")
=text(a1,"dddd")

 

[Dave Peterson]

You've got other replies at your other post.

I use win xp home edition, sp2, excel 2003

Can someone tell me how I can insert day of the week next to my date,
example May 18, 2006 Thurs

 

[Dave Peterson]

Oops. I didn't notice that it was cross posted.

You've got other replies at your other post.

 

[Gary''s Student]

=today() formatted as:
mmm dd, yyyy dddd