| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a date column from seperate data
My Apologies
I had meant to type just =DATE(A1,B1,C1) Format the cell in your desired date format Regards Roger Govier T.O. wrote: the functions YEAR(), MONTH() and DAY() require a serial number, representing a whole date as input. any other ideas? please?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| displaying data within column | Charts and Charting in Excel | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
