Date help please
 

I have a worksheet with day in A1, month in A2 and Year in A3. The
cells are formatted =Day(xx),=Month(xx),=Year(xx) repectively, where xx
represent the cells containing the source data. I want to combine
these into another cell that shows the precise full date - have been
playing with the '&" function to no avail.

Any help much appreciated

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=499261

Date help please
 

Does this work?

=DATE(A3,A2,A1)


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=499261

Date help please
 

Works like a charm!

Thanks Vito

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=499261