Solved

Stored as date format, cut at comma

Posted on 2013-12-03
4
194 Views
Last Modified: 2013-12-03
If you go to Sales in that attached ss, you will see the cell i have highlighted yellow, can someone make that cut Monday out of col a, but for consistency down the range, cut just before comma, also i belive that the col a is stored as date, causing it to return digits

Many thanks
The-Howl-Sales-Kat.xlsx
0
Comment
Question by:Seamus2626
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
Comment Utility
=TEXT(A2,"dddd")
0
 
LVL 9

Accepted Solution

by:
BlueYonder earned 500 total points
Comment Utility
Here is the formula =CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
0
 

Author Closing Comment

by:Seamus2626
Comment Utility
Thanks!
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
Comment Utility
Hi, what was wrong with my formula?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now