convert date to Day of the Week

's Computer Specifications

How can I convert a date to the 'Day of the week'? ie Mon, Tue .....

's Computer Specifications

> How can I convert a date to the 'Day of the week'? ie Mon, Tue

Let's say your date is in A1, then this...

=TEXT(A1,"ddd")

will give you the day's name abbreviated and this...

=TEXT(A1,"dddd")

will give you the full name of the day.

Rick Rothstein (MVP - Excel)

's Computer Specifications

On Jan 13, 2:16*am, "APPLE" <kris8...@singnet.com.sg> wrote:
> How can I convert a date to the 'Day of the week'? *ie Mon, Tue .....

If the SAME cell just format it to ddd

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert regular Date to Week Ending or Week Beginning Dates	Sam H	Microsoft Excel Misc	4	27th Jan 2010 03:27 PM
Convert today's date -7 days to week YYYYWW (last week)	AFSSkier	Microsoft Access Queries	4	26th Nov 2008 09:09 PM
Convert Date to week	SF	Microsoft Access	2	26th Sep 2006 02:55 PM
convert date to day of week?	=?Utf-8?B?TUplZGRyeQ==?=	Microsoft Access	2	14th Mar 2006 09:17 PM
Convert week # into date of the first day of week in SQL	=?Utf-8?B?QWNjZXNzIFRvbQ==?=	Microsoft Access Reports	15	21st Oct 2004 10:01 PM