Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2015, 03:21 AM
caz46 caz46 is offline Formula to return a date Windows 7 32bit Formula to return a date Office 2007
Advanced Beginner
Formula to return a date
 
Join Date: Feb 2011
Posts: 73
caz46 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-15-2015, 04:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to return a date Windows 7 64bit Formula to return a date Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 04-15-2015, 05:07 AM
caz46 caz46 is offline Formula to return a date Windows 7 32bit Formula to return a date Office 2007
Advanced Beginner
Formula to return a date
 
Join Date: Feb 2011
Posts: 73
caz46 is on a distinguished road
Default

Hi,

Thanks for taking the time to reply.

With which formula would I need to do this?

Thanks
Reply With Quote
  #4  
Old 04-15-2015, 08:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to return a date Windows 7 64bit Formula to return a date Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Formula to return a date 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
Formula to return a date Need a date formula MPAVLAS Excel 3 08-12-2010 10:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft