Convert date parts to date

[ColMac]

Hi folks, new member here from the UK.

I've inherited a list which includes thousands of dates of birth

However, the dates have been input in individual (Numeric) columns for each of Day, Month & Year (UK date style).

I'd like to convert them into a single date field but my brain can't think of the way to do it.

Any suggestions welcome. Thanks

22	5	1893
5	6	1893
5	7	1893
17	10	1894
18	3	1895
3	6	1895
4	6	1895
4	7	1895
15	7	1895
30	9	1895
30	9	1895

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[ColMac]

I meant to add there is a mix of dates pre and post 1900

Colin

 

[Fluff]

If you need to keep them as "dates" then have a look here http://spreadsheetpage.com/index.php/tip/working_with_pre_1900_dates/

 

[ColMac]

If you need to keep them as "dates" then have a look here http://spreadsheetpage.com/index.php/tip/working_with_pre_1900_dates/

Thanks, I'll downlaod and play with that

Colin