Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Day of the week
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! -- Donna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Day of the week
Post the formula you are using and some sample data
"Donna" wrote: 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! -- Donna |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Day of the week
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. "Donna" wrote: 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! -- Donna |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Day of the week
=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. -- Biff Microsoft Excel MVP "Ork" wrote in message ... 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. "Donna" wrote: 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! -- Donna |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Day of the week
On Fri, 16 Oct 2009 22:12:50 -0400, "T. Valko"
wrote: =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/te...CT101440991033 or http://office.microsoft.com/en-us/te...CT101440991033 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Day of the week
On Sat, 17 Oct 2009 20:46:07 -0700, WallyWallWhackr
<wallywallwhackr@thematrixattheendofthemushroomste m.org wrote: On Fri, 16 Oct 2009 22:12:50 -0400, "T. Valko" wrote: =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... SNIP! or http://office.microsoft.com/en-us/te...CT101440991033 Oooops... one not working... The first... I snipped it... here... http://office.microsoft.com/en-us/te...070531033.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |