Formating Day of the week

[Donna]

I have a monthly template that I use for scheduling. Once I change the month,
I have the worksheet formulated to change the dates. I then used a lookup
table to add what the day of week is. I want to show the abbreviation instead
of the whole word. I tried adding text(be,"ddd") to the formula but could not
get it to work. Any suggestions.

Thank you!

 

[Mike H]

Post the formula you are using and some sample data

 

[Ork]

Donna,
Hi.
How about =left(text(a1,"dddd"),3)
which would yeield Fri
if a1=today()
3 would be the # of chars to display

I'm sure there are other ways.
Not sure if this is what you wanted either.

 

[T. Valko]

=left(text(a1,"dddd"),3)

This will do the same thing:

=TEXT(A1,"ddd")

"ddd" = short weekday name format: Mon, Tue, Wed, Thu, Fri, Sat, Sun

"dddd" = long weekday name format: Monday, Tuesday, Wednesday, etc.

 

[WallyWallWhackr]

=left(text(a1,"dddd"),3)

This will do the same thing:

=TEXT(A1,"ddd")

"ddd" = short weekday name format: Mon, Tue, Wed, Thu, Fri, Sat, Sun

"dddd" = long weekday name format: Monday, Tuesday, Wednesday, etc.

My handling is similar.

All of my stuff is free to use any, all, or part of as desired.

There are some errors with some local sheet hyperlinks (I missed
those), but the workbook itself is pretty good overall.

Two, actually...

http://office.microsoft.com/en-us/templates/TC300063451033.aspx?CategoryID=CT101440991033

or

http://office.microsoft.com/en-us/templates/TC300067601033.aspx?CategoryID=CT101440991033

 

[WallyWallWhackr]

My handling is similar.

All of my stuff is free to use any, all, or part of as desired.

There are some errors with some local sheet hyperlinks (I missed
those), but the workbook itself is pretty good overall.

Two, actually...

SNIP!

or

http://office.microsoft.com/en-us/templates/TC300067601033.aspx?CategoryID=CT101440991033

Oooops... one not working... The first... I snipped it... here...

http://office.microsoft.com/en-us/templates/TC300070531033.aspx