software

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 ThursSachi Noma wrote:
gt; I use win xp home edition, sp2, excel 2003
gt;
gt; Can someone tell me how I can insert day of the week next to my date,
gt; example May 18, 2006 Thurs

TEXT(NOW(),quot;dddquot;)
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,quot;dddquot;)
=text(a1,quot;ddddquot;)
Sachi Noma wrote:
gt;
gt; I use win xp home edition, sp2, excel 2003
gt;
gt; Can someone tell me how I can insert day of the week next to my date,
gt; example May 18, 2006 Thurs

--

Dave Peterson

You've got other replies at your other post.

Sachi Noma wrote:
gt;
gt; I use win xp home edition, sp2, excel 2003
gt;
gt; Can someone tell me how I can insert day of the week next to my date,
gt; example May 18, 2006 Thurs

--

Dave Peterson

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

Dave Peterson wrote:
gt;
gt; You've got other replies at your other post.
gt;
gt; Sachi Noma wrote:
gt; gt;
gt; gt; I use win xp home edition, sp2, excel 2003
gt; gt;
gt; gt; Can someone tell me how I can insert day of the week next to my date,
gt; gt; example May 18, 2006 Thurs
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson

=today() formatted as:
mmm dd, yyyy dddd
--
Gary's Studentquot;Sachi Nomaquot; wrote:

gt; I use win xp home edition, sp2, excel 2003
gt;
gt; Can someone tell me how I can insert day of the week next to my date,
gt; example May 18, 2006 Thurs
gt;
gt;