date in diff. cells
 

I have a excel sheet with the dates in 3 different cells, e.g. 21/05/2006,
appears like
cell a1 21, cel b1 05 and cell c1 2006

tried merging the cells but did not work, need to have this date in one cell

any help will be appreciated

thanks

date in diff. cells
 

=TEXT(A1&"/"&B1&"/"&C1,"dd/mm/yy")


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564061

date in diff. cells
 

thank you very much

"VBA Noob" wrote:


=TEXT(A1&"/"&B1&"/"&C1,"dd/mm/yy")


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564061

date in diff. cells
 

=DATE(C1,B1,A1)

HTH
--
AP

"Gerald" a écrit dans le message de news:
...
I have a excel sheet with the dates in 3 different cells, e.g. 21/05/2006,
appears like
cell a1 21, cel b1 05 and cell c1 2006

tried merging the cells but did not work, need to have this date in one
cell

any help will be appreciated

thanks