| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
mm/dd/yy vs Mon, Tue, Wed etc
Excel2003 ...
Col A contains dates ... Format = mm/dd/yy Cols B thru H contain ... Text = Mon, Tue, Wed, Thu, Fri, Sat, Sun I wish to format & setup so I can have a formula under each day of the week that will peg the day vs the mm/dd/yy date in Col A. If Col A = 01/17/07 ... No-No-Yes-No-No-No-No ... (Yes = Weds) If Col A = 01/19/07 ... No-No-No-No-Yes-No-No ... (Yes = Fri) If Col A = 03/05/07 ... Yes-No-No-No-No-No-No ... (Yes = Mon) Thanks ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) | Excel Discussion (Misc queries) | |||
| Create a date column (MM/DD/YY) that fill sout automatically? | Excel Worksheet Functions | |||
| How do I change dates from dd/mm/yy to mm/dd/yy | Setting up and Configuration of Excel | |||
| HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY? | Excel Worksheet Functions | |||
| HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY? | Excel Worksheet Functions | |||
Threaded Mode
