Solved

Display a Date value by combining General values from other cells in Excel

Posted on 2011-02-14
4
254 Views
Last Modified: 2012-05-11
Hello,

In Excel (2007), suppose that columns A, B and C have a General format and contain values representing month, day, and year respectively.  What formula in column D will combine the A-C values from the corresponding row so that column D will display the full date with the format m/d/yyyy?

For example:

    If A1 = 3, B1 = 16 and C1 = 2006, then D1 = 3/16/2006
    If A2 = 11, B2 = 5 and C2 = 2010, then D2 = 11/5/2010
    If A3 = 7, B3 = 31 and C3 = 2008, then D3 = 7/31/2008
    and so on...

Thanks
0
Comment
Question by:Steve_Brady
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
Comment Utility
Just use DATE function, e.g. in D1

=DATE(C1,A1,B1)

the cell format should default to your default date setting - change format as reuierd

regards, barry
0
 

Author Comment

by:Steve_Brady
Comment Utility
Thanks Barry,

I had a feeling that there was some simple way to do that but I couldn't get it.  I don't know why but I was trying to use =TEXT(value, format_text) with "m/d/yyyy" as the format but I couldn't determine the value.  Is there any way to do it using =TEXT() or is that a dead-end?

Thanks again.
0
 
LVL 50

Expert Comment

by:Dave Brett
Comment Utility
Dead end

TEXT changes formats of values, whereas DATE actually creates a value

Cheers

Dave
0
 
LVL 50

Expert Comment

by:barry houdini
Comment Utility
Hi, Steve,

You could use the DATE function inside a TEXT function like this

=TEXT(DATE(C1,A1,B1),"m/d/yyyy")

but your result is then text and not a date....so unless you have a specific reason why you'd want it to be text then it's probably better to keep as a true date, you can format it any way you want.

regards, barry
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now