| 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 |
| 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 | |||
Threaded Mode
