date problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
=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
 
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
 
Thank you both very much
--
Hoyos


Max said:
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
Click to expand...
 
Back
Top