| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to CONCATENATE two dates field together | Excel Worksheet Functions | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| concatenate with dates | Excel Discussion (Misc queries) | |||
| concatenate dates? | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Threaded Mode
