| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to take a date 2006/02/10 & break it into separate columns
On Wed, 20 Sep 2006 08:37:03 -0700, Curtis
wrote: If it is a true Excel Date, then, with the date in A1: B1: =YEAR(A1) C1: =MONTH(A1) D1: =DAY(A1) or something similar. You could also use custom formatting if all you wanted to do was display the date portions, as opposed to actually having the numerical year, month, day in the different columns. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging separate date and time columns into one | Excel Discussion (Misc queries) | |||
| I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
| The way the date displays in columns | New Users to Excel | |||
| Divide date into separate columns | Excel Worksheet Functions | |||
| How do I concatenate two columns when one is in date format? | Excel Discussion (Misc queries) | |||
Hybrid Mode
