| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problem
I have 3 columns. col A =day ie 1, 2 ,3 ... col B = month. col C = year.
How can I merge them all to read date format dd-mm-yy in one cell -- Hoyos |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date problem
=DATE(C1,B1,A1) if the inputs are all numbers, or
=DATEVALUE(A1&"/"&B1&"/"&C1) which will also work if the month is in text format -- David Biddulph "Hoyos" wrote in message ... I have 3 columns. col A =day ie 1, 2 ,3 ... col B = month. col C = year. How can I merge them all to read date format dd-mm-yy in one cell -- Hoyos |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date problem
Assuming in A1 down are the day nos: 1,2,3,...31,
in B1 down are the month nos: 1,2,...12 and in C1 down are the full year nos: 2006, 2007, etc Then in D1: =DATE(C1,B1,A1) with D1 formatted as: dd-mm-yy should return the results Copy D1 down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Hoyos" wrote: I have 3 columns. col A =day ie 1, 2 ,3 ... col B = month. col C = year. How can I merge them all to read date format dd-mm-yy in one cell -- Hoyos |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date problem
Thank you both very much
-- Hoyos "Max" wrote: Assuming in A1 down are the day nos: 1,2,3,...31, in B1 down are the month nos: 1,2,...12 and in C1 down are the full year nos: 2006, 2007, etc Then in D1: =DATE(C1,B1,A1) with D1 formatted as: dd-mm-yy should return the results Copy D1 down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Hoyos" wrote: I have 3 columns. col A =day ie 1, 2 ,3 ... col B = month. col C = year. How can I merge them all to read date format dd-mm-yy in one cell -- Hoyos |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date problem
welcome, Hoyos.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Hoyos" wrote in message ... Thank you both very much -- Hoyos |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
| Date problem | Excel Discussion (Misc queries) | |||
| date problem | Excel Worksheet Functions | |||
| 'Date' problem | Excel Discussion (Misc queries) | |||
| Date Problem | New Users to Excel | |||
Linear Mode
