+ Reply to Thread
Results 1 to 4 of 4

Ex. Wednesday to read "W"

  1. 12-12-2013, 01:53 PM #1
    jlo33
    jlo33 is offline
    Registered User
    Join Date
    05-31-2013
    Location
    Somewhere
    MS-Off Ver
    Microsoft 365
    Posts
    80

    Ex. Wednesday to read "W"

    Hi!

    I have this formula right now:

    =TEXT(B$7, "ddd").

    B7 is a cell that contains the date but the formula is in a different cell to show the day of the week for that corresponding day. It shows up as "Wed" for example. I am wanting to skip that and for it to read just "W".

    How do I change my formula to make that happen?
    Reply With QuoteRegister To Reply
  2. 12-12-2013, 01:57 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Ex. Wednesday to read "W"

    Not sure why you would want to do that - how would you know if it was Tuesday or Thursday - Saturday or Sunday?

    Try this though...
    =LEFT(TEXT(B$7, "ddd"),1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-12-2013, 02:01 PM #3
    jlo33
    jlo33 is offline
    Registered User
    Join Date
    05-31-2013
    Location
    Somewhere
    MS-Off Ver
    Microsoft 365
    Posts
    80

    Re: Ex. Wednesday to read "W"

    Bingo!

    Thanks!
    Reply With QuoteRegister To Reply
  4. 12-12-2013, 02:08 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Ex. Wednesday to read "W"

    Happy to help Please mark this thread SOLVED by using the thread tools at the top of the page
    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. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. Read select "text" from "Text File" using VBA code
    By naven_sg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2012, 04:01 PM
  4. Solution "Your changes could not be saved" "The document may be read-only or encrypted"
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 08-07-2006, 01:35 AM
  5. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 PM

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