Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |