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

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

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

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

date problem
 

welcome, Hoyos.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hoyos" wrote in message
...
Thank you both very much
--
Hoyos