![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| HELP: Return a value with a date that falls between two other dates | hionman | Excel | 5 | 11-12-2014 09:56 AM |
| MS Excel Investing Formula for calculating stock return HELP pls | doug6388 | Excel | 0 | 09-05-2014 08:48 PM |
Excel Formula: return a range of cells that match
|
tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
| Formula to calculate Date and Time | funkyfido | Excel | 2 | 06-25-2013 04:25 PM |
Need a date formula
|
MPAVLAS | Excel | 3 | 08-12-2010 10:04 PM |