Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 07:56 AM.


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