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

Have you tried formatting as "dd mmm"" ? ( without the double quotes)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi,

Thanks for taking the time to reply.

With which formula would I need to do this?

Thanks

Just enter =A1 in the third column ( A being date of birth) and Custom format the cell as suggested

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post