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

[TABLE="width: 123"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]22[/TD]
[TD]5[/TD]
[TD]1893[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]1893[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]7[/TD]
[TD]1893[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]10[/TD]
[TD]1894[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]3[/TD]
[TD]1895[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]6[/TD]
[TD]1895[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6[/TD]
[TD]1895[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7[/TD]
[TD]1895[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]7[/TD]
[TD]1895[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]9[/TD]
[TD]1895[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]9[/TD]
[TD]1895
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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