• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

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

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
Steve_Brady
Asked:
Steve_Brady
  • 2
1 Solution
 
barry houdiniCommented:
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
 
Steve_BradyAuthor Commented:
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
 
Dave BrettCommented:
Dead end

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

Cheers

Dave
0
 
barry houdiniCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now