Concatenate Dates
I am trying to get cell A5 to read AL, Oct05- Feb06, but it currently reads
AL, 38777 38777. The formula i am using is
=IF(B6="","",IF(E6=0,CONCATENATE(B6,", ",C6),CONCATENATE(B6,",
",DATE(YEAR(E6),MONTH(E6),1)," ",E6)))
Any suggestions?????
|