Changing Monday to M,... in excel

  • Thread starter Thread starter d9pierce
  • Start date Start date
D

d9pierce

HI all,
Does anyone know what the formula is to change Monday to M, Tuesday to
T, Wednesday to W and so on. I can change it to Mon, Tue, Wed... but
cant seam to get just one letter. I am using a sort of bar chart that
my company uses and when I fill in a date which returns just that day
like 1,2,3,...in a small box, I need to put the day of the week above
it in another cell with just one letter. They use it as a schedule as
they are just to stupid to use MS Project and make things simple for
all, but that is another story. Would apriciate some help. Thanks
Dave
(e-mail address removed)
 
With a date in A1, you could use this:

=LEFT(TEXT(A1,"ddd"))

which will give you the initial letter of the day. Not sure how you
would distinguish between Tuesday and Thursday, though, or Saturday
and Sunday.

Hope this helps.

Pete
 
Thank you, that worked well for that. I really dont have to differ
between Tues / Thurs as it is a very simple claendar type spreadsheet.
Basically they have taken a spreadsheet, and put in the day of the
week such as M, T, W... and then put the day of the week under it such
as 23,24,25... then they just fill in boxes below those dates for with
shade for a schedule. In any event, they are not ready to join the
real world so I have to deal with changing all these boxes for up to
an 8 week schedule. The M, T, W... could really just be set text. What
I would like is to be able to enter a date as a schedule start date
and have that format the 23,24,25... automatically. I was able to do
the start date as 2/23/09 and then I formatted the first box for a
number as =TEXT(L8,"d") which brings me a date number of 23, cool!
What I have not been able to figure out is how to add to that number
in increments? In Cell G13 I put the above formula and then I tried to
add one day to the next cell H13 , which I tried H13+1, =Text
(L8+1,"d"), and so on but these did not work, ANY SUGGESTIONS on how
to add these increments? We dont use Saturday or Sunday so that is no
big deal but I would really like to just type in a date and it fill in
the other cells that will calculate as a calendar days would. Thanks
so much, dave
 
In H13 you could put the formula:

=$L$8+COLUMN(A1)

if you want to copy across into I13, J13 etc, or:

=$L$8+ROW(A1)

if you want to copy down.

The COLUMN(A1) or ROW(A1) will return 1, but in the next cell it will
become COLUMN(B1) or ROW(A2) which will return 2, and so on.

You can wrap each of these with the TEXT function to give you the day
(or the letter of the day).

Hope this helps.

Pete
 
You can have a try using following simple excel formula
=MID(A1,1,1)
Where A1 contains the day name

Chris
 
You mean:

=LEFT(A1,1)

Shane Devenshire said:
Hi,

If the days are in A1 then

=LEFT(A1)

will do it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
Click to expand...
 
I don't think he did. It is poor practice IMO, but if you omit the number of
characters, one is assumed. Same with Right.
 
Back
Top