| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format to: S-M-T-W-T-F-S?
Excel2003
Cell A2 contains a Date ... 01/01/08 Range G4:AK4 ... contains formula which calculates Days of the month 1-31 (G4 contains ... =A2 (format "d") ... H4 contains =G4+1 (format "d") ... etc) Range G3:AK3 ... contains formula ... G3=G4, H3=H4, I3=I4 etc Now I wish to format Range G3:AK3 to return ... S, M, T, W, T, F, S ... based on day of week found in Range G4:AK4. Can I do this with "format" ... or ... do I need formula? ... Either way ... How? Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to: S-M-T-W-T-F-S?
The WEEKDAY formula should be what you're looking for.
"Ken" wrote: Excel2003 Cell A2 contains a Date ... 01/01/08 Range G4:AK4 ... contains formula which calculates Days of the month 1-31 (G4 contains ... =A2 (format "d") ... H4 contains =G4+1 (format "d") ... etc) Range G3:AK3 ... contains formula ... G3=G4, H3=H4, I3=I4 etc Now I wish to format Range G3:AK3 to return ... S, M, T, W, T, F, S ... based on day of week found in Range G4:AK4. Can I do this with "format" ... or ... do I need formula? ... Either way ... How? Thanks ... Kha |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to: S-M-T-W-T-F-S?
I think you'll need a formula:
=text(g3,"ddd") will provide the 3 character abbreviation for the day. So =left(text(g3,"ddd"),1) will return the first character of the abbreviation. Ken wrote: Excel2003 Cell A2 contains a Date ... 01/01/08 Range G4:AK4 ... contains formula which calculates Days of the month 1-31 (G4 contains ... =A2 (format "d") ... H4 contains =G4+1 (format "d") ... etc) Range G3:AK3 ... contains formula ... G3=G4, H3=H4, I3=I4 etc Now I wish to format Range G3:AK3 to return ... S, M, T, W, T, F, S ... based on day of week found in Range G4:AK4. Can I do this with "format" ... or ... do I need formula? ... Either way ... How? Thanks ... Kha -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to: S-M-T-W-T-F-S?
Try this in =CHOOSE(WEEKDAY(G3),"S","M","T","W","T","F","S")
On Jun 4, 12:09*am, Ken wrote: Excel2003 Cell A2 contains a Date ... 01/01/08 Range G4:AK4 ... contains formula which calculates Days of the month 1-31 (G4 contains ... =A2 (format "d") ... H4 contains =G4+1 (format "d") .... etc) Range G3:AK3 ... contains formula ... G3=G4, H3=H4, I3=I4 etc Now I wish to format Range G3:AK3 to return ... S, M, T, W, T, F, S ... based on day of week found in Range G4:AK4. Can I do this with "format" ... or ... do I need formula? ... Either way .... How? Thanks ... Kha |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format to: S-M-T-W-T-F-S?
Hi,
Put this in G3 and drag right =LEFT(TEXT(G4,"ddd"),1) Mike "Ken" wrote: Excel2003 Cell A2 contains a Date ... 01/01/08 Range G4:AK4 ... contains formula which calculates Days of the month 1-31 (G4 contains ... =A2 (format "d") ... H4 contains =G4+1 (format "d") ... etc) Range G3:AK3 ... contains formula ... G3=G4, H3=H4, I3=I4 etc Now I wish to format Range G3:AK3 to return ... S, M, T, W, T, F, S ... based on day of week found in Range G4:AK4. Can I do this with "format" ... or ... do I need formula? ... Either way ... How? Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| Decide comment format 'globally'? Restore format with ws_change? | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Hybrid Mode
