+ Reply to Thread
Results 1 to 7 of 7

Date to Match day of the week

  1. 11-17-2014, 10:38 AM #1
    nic716
    nic716 is offline
    Registered User
    Join Date
    09-09-2014
    Location
    Town of Tonawanda
    MS-Off Ver
    2010 Excel
    Posts
    15

    Red face Date to Match day of the week

    Good Morning!

    I have a list of future dates, and I need to create another colum to tell me what day of the week it is.

    Example:

    11/28/2014 Friday
    12/4/2014 Thursday

    Thoughts?

    Please and thank you!!
    Reply With QuoteRegister To Reply
  2. 11-17-2014, 10:40 AM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Date to Match day of the week

    Try

    =TEXT(A1,"dddd")
    Reply With QuoteRegister To Reply
  3. 11-17-2014, 10:41 AM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Date to Match day of the week

    Like this...

    =TEXT(A2,"dddd")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 11-17-2014, 10:42 AM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Date to Match day of the week

    "dddd" will return the long weekday name: Friday

    "ddd" will return the short weekday name: Fri
    Reply With QuoteRegister To Reply
  5. 11-17-2014, 10:42 AM #5
    nic716
    nic716 is offline
    Registered User
    Join Date
    09-09-2014
    Location
    Town of Tonawanda
    MS-Off Ver
    2010 Excel
    Posts
    15

    Re: Date to Match day of the week

    Wonderful!!
    Thank you very much
    Reply With QuoteRegister To Reply
  6. 11-17-2014, 10:44 AM #6
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Date to Match day of the week

    You're welcome.
    Reply With QuoteRegister To Reply
  7. 11-17-2014, 10:50 AM #7
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Date to Match day of the week

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need Sum total for Week to Date, Previous Week to Date , Month to Date and ....
    By jubiesxl in forum Excel General
    Replies: 13
    Last Post: 10-10-2014, 06:50 AM
  2. Calculating if a bill needs to be paid in a week given the week starting date
    By AKF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2013, 08:46 AM
  3. Excel 2007 : Need corresponding Week Number and Week Begining Date to appear next to data search
    By DataDog in forum Excel General
    Replies: 14
    Last Post: 02-15-2012, 10:23 AM
  4. week start date and end date based on week number
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 12:39 PM
  5. Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1