| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pick up date, month and year from a date
I have date in say column b. I need to have year, month and date from column b to column c, column d and column e so I can sort data by month or date. I know it is simple formulae but have forgotten it. Appreciate help. thanks much vikkam  -- vikkam ------------------------------------------------------------------------ vikkam's Profile: http://www.excelforum.com/member.php...fo&userid=1266 View this thread: http://www.excelforum.com/showthread...hreadid=565419 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| holiday dates | Excel Worksheet Functions | |||
| how to insert month date year and day of week | Excel Worksheet Functions | |||
| Format date with just month and year | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| create a date from year, day and month | Excel Worksheet Functions | |||
Threaded Mode
