Hi, I have 3 columns of data relating to peoples date of birth. The first column contains the date they were born and the second contains the month number in which they were born. I would like the third column to show their date of birth without the year i.e. 23 Jan.

Is there a formula that can do this, I have had a look but can't find anything to match my needs.

Thanks in advance
Caz