#1
|
|||
|
|||
Formula to return a date
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 |
#2
|
||||
|
||||
Have you tried formatting as "dd mmm"" ? ( without the double quotes)
__________________
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 |
#3
|
|||
|
|||
Hi,
Thanks for taking the time to reply. With which formula would I need to do this? Thanks |
#4
|
||||
|
||||
Just enter =A1 in the third column ( A being date of birth) and Custom format the cell as suggested
__________________
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 |
|
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 |