reconstitute date

[namsilat]

I was wondering if I can reconstruct a date in a cell by using
numerics from other cells. For example, if I have "2" in A1, "15" in
A2, and "2011" in A3, is there a way I can put those numbers together
and produce "2011-02-15" in A4?

 

[Gord Dibben]

In A4...............=DATEVALUE(A1&"/"&A2&"/"&A3)

will return serial number 40589

Format as Custom yyyy-mm-dd


Gord Dibben MS Excel MVP

 

[Rick Rothstein]

In A4...............=DATEVALUE(A1&"/"&A2&"/"&A3)

will return serial number 40589

Format as Custom yyyy-mm-dd

A little more straightforward formula I would think...

In A4..... =DATE(A3,A1,A2)

Rick Rothstein (MVP - Excel)

 

[Gord Dibben]

MUCH more straightforward.

Thanks Gord

 

[Stan Brown]

I was wondering if I can reconstruct a date in a cell by using
numerics from other cells. For example, if I have "2" in A1, "15" in
A2, and "2011" in A3, is there a way I can put those numbers together
and produce "2011-02-15" in A4?

=DATE(year, month, day)

The help topic "worksheet functions by category" is your friend.

Once you know the name of the function you want, a wizard will help
you build it if you wish. In an empty cell, type =date( including
the open paren and then press Ctrl-A.