combining 3 columns (year, month, day) into one column

[Lorraine]

Hi

I have 3 columns, one for year, one for month and one for
day, I need to join them into one column as a date that I
can then use in a formula. Any ideas?

thanks

 

[Leo Heuser]

Hi Lorraine

One way:

=DATE(YEAR(A1),MONTH(B1),DAY(C1))