PC Review


Reply
Thread Tools Rate Thread

convert date to Day of the Week

 
 
APPLE
Guest
Posts: n/a
 
      13th Jan 2011
How can I convert a date to the 'Day of the week'? ie Mon, Tue .....


 
Reply With Quote
 
 
 
 
Rick Rothstein
Guest
Posts: n/a
 
      13th Jan 2011
> 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)
 
Reply With Quote
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      13th Jan 2011
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:44 AM.