| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine as Date
Hello!
I have a file that has Year in one column, Month in a second column, and day in the third column. I would like to combine this to be a date. Basically, is there an equivalent of the DATESERIAL SQL function in Excel? Thanks! Leslie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine as Date
What about
=DATE(A2,B2,C2) Mike "Leslie W." wrote: Hello! I have a file that has Year in one column, Month in a second column, and day in the third column. I would like to combine this to be a date. Basically, is there an equivalent of the DATESERIAL SQL function in Excel? Thanks! Leslie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine as Date
Mike,
That's exactly what I'm looking for. Thanks! Leslie "Mike H" wrote: What about =DATE(A2,B2,C2) Mike "Leslie W." wrote: Hello! I have a file that has Year in one column, Month in a second column, and day in the third column. I would like to combine this to be a date. Basically, is there an equivalent of the DATESERIAL SQL function in Excel? Thanks! Leslie |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine as Date
Glad I could help
"Leslie W." wrote: Mike, That's exactly what I'm looking for. Thanks! Leslie "Mike H" wrote: What about =DATE(A2,B2,C2) Mike "Leslie W." wrote: Hello! I have a file that has Year in one column, Month in a second column, and day in the third column. I would like to combine this to be a date. Basically, is there an equivalent of the DATESERIAL SQL function in Excel? Thanks! Leslie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine day text and date problems | Excel Discussion (Misc queries) | |||
| How do i combine 2 cells contain date in one cell, | Excel Worksheet Functions | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| Combine date with text | Excel Worksheet Functions | |||
Linear Mode
