?
Solved

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

Posted on 2011-02-14
4
Medium Priority
?
261 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 34893371
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
ID: 34893418
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
ID: 34893437
Dead end

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

Cheers

Dave
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 34893438
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

743 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