date problem

[Guest]

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

 

[David Biddulph]

=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

 

[Guest]

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

 

[Guest]

Thank you both very much
--
Hoyos

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]

welcome, Hoyos.