how to insert day of the week
 

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

how to insert day of the week
 

Sachi Noma wrote:
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")

how to insert day of the week
 

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")



Sachi Noma wrote:

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

how to insert day of the week
 

You've got other replies at your other post.

Sachi Noma wrote:

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

how to insert day of the week
 

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

Dave Peterson wrote:

You've got other replies at your other post.

Sachi Noma wrote:

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

--

Dave Peterson

how to insert day of the week
 

=today() formatted as:
mmm dd, yyyy dddd
--
Gary's Student


"Sachi Noma" wrote:

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