View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
peter.thompson
 
Posts: n/a
Default 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