asked on

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

ASKER CERTIFIED SOLUTION

barry houdini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve_Brady

ASKER

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.

Dave

Dead end

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

Cheers

Dave

barry houdini

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