Identification of what day it is
Hi
I was hoping someone could shed some light on this.I want column B to identify the day in column A and express it as text. I.E. when column A is 01/10/07,coumn B displays ' Mon' column A column B 01/10/2007 02/10/2007 03/10/2007 Thanks David |
Identification of what day it is
Hi David,
In B1: =A1 Format Custom as "ddd" Copy down as far as needed -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... | Hi | | I was hoping someone could shed some light on this.I want column B to | identify the day in column A and express it as text. | | I.E. when column A is 01/10/07,coumn B displays ' Mon' | | | column A column B | 01/10/2007 | 02/10/2007 | 03/10/2007 | | Thanks | David | |
Identification of what day it is
=TEXT(A1,"ddd")
" wrote: Hi I was hoping someone could shed some light on this.I want column B to identify the day in column A and express it as text. I.E. when column A is 01/10/07,coumn B displays ' Mon' column A column B 01/10/2007 02/10/2007 03/10/2007 Thanks David |
Identification of what day it is
On Mar 8, 6:35*pm, Teethless mama
wrote: =TEXT(A1,"ddd") " wrote: Hi I was hoping someone could shed some light on this.I want column B to identify the day in column A and express it as text. I.E. when column A is 01/10/07,coumn B displays *' Mon' column A * * * * * * column B *01/10/2007 *02/10/2007 *03/10/2007 Thanks David- Hide quoted text - - Show quoted text - Thanks for responding Whenever i use =TEXT(A1,"ddd") ,column B displays '01/10/2007' Any suggestions. David |
Identification of what day it is
It sounds like your "date" is actually text with one or more leading spaces
in front of it. If I am correct, either convert the "date" to a real date or, at minimum, remove the leading spaces, and Teethless mama's formula should work. If you don't want to modify what you now have, then (again, if I am correct) this formula should work for you... =TEXT(TRIM(A1),"ddd") Rick wrote in message ... On Mar 8, 6:35 pm, Teethless mama wrote: =TEXT(A1,"ddd") " wrote: Hi I was hoping someone could shed some light on this.I want column B to identify the day in column A and express it as text. I.E. when column A is 01/10/07,coumn B displays ' Mon' column A column B 01/10/2007 02/10/2007 03/10/2007 Thanks David- Hide quoted text - - Show quoted text - Thanks for responding Whenever i use =TEXT(A1,"ddd") ,column B displays '01/10/2007' Any suggestions. David |
Identification of what day it is
When you press Ctrl+Accent grave (`), the key above the tab key, does cell
A1 display 39092, the date serial number for 1/10/2007? Or do you see 1/10/2007? Press Ctrl+Accent grave (`) to return to normal display. If you see 1/10/2007, your "date" is text with perhaps a space in it. That is to say, it's not a date. Tyro wrote in message ... On Mar 8, 6:35 pm, Teethless mama wrote: =TEXT(A1,"ddd") " wrote: Hi I was hoping someone could shed some light on this.I want column B to identify the day in column A and express it as text. I.E. when column A is 01/10/07,coumn B displays ' Mon' column A column B 01/10/2007 02/10/2007 03/10/2007 Thanks David- Hide quoted text - - Show quoted text - Thanks for responding Whenever i use =TEXT(A1,"ddd") ,column B displays '01/10/2007' Any suggestions. David |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com