Concatenate with IF

Excel-lent friends,

I'm working on a little inventory project in which I want to transition from Excel to Access. For a given item, the prior user has created a series of columns showing anytime it is moved. For example,
1.PNG

What I want to do is combine all of those moves from columns F through O into a Remarks column in E, delimited by a comma. I created this initially:

=CONCATENATE(

F2," ",TEXT(G2,"mm/dd/yyyy"),",",
H2," ",TEXT(I2,"mm/dd/yyyy"),",",
J2," ",TEXT(K2,"mm/dd/yyyy"),",",
L2," ",TEXT(M2,"mm/dd/yyyy"),",",
N2," ",TEXT(O2,"mm/dd/yyyy"))

The problem was, for the non-blank values it gave me a 1/1/1900 result. I want to only combine if the date field has a value, and thought to use this IF statement:

=CONCATENATE(

IF(ISBLANK(G2), ??, F2," ",TEXT(G2,"mm/dd/yyyy"),",",)
IF(ISBLANK(I2), ??, H2," ",TEXT(I2,"mm/dd/yyyy"),",",)
IF (ISBLANK(K2), ??, J2," ",TEXT(K2,"mm/dd/yyyy"),",",)
IF (ISBLANK(M2), ??, L2," ",TEXT(M2,"mm/dd/yyyy"),",",)
IF (ISBLANK(O2), ??, N2," ",TEXT(O2,"mm/dd/yyyy")))

This gave me an error of too many arguments. Can any of you provide a quick help on syntax to get me the result I'm looking for?

I tested syntax but cannot test for data without your actual file (I'm not going to type in all your data from a screenshot). But try this:

=CONCATENATE(

IF(ISBLANK(G2),"",CONCATENATE(F2," ",TEXT(G2,"mm/dd/yyyy"),",")),
IF(ISBLANK(I2),"",CONCATENATE(H2," ",TEXT(I2,"mm/dd/yyyy"),",")),
IF(ISBLANK(K2),"",CONCATENATE(J2," ",TEXT(K2,"mm/dd/yyyy"),",")),
IF(ISBLANK(M2),"",CONCATENATE(L2," ",TEXT(M2,"mm/dd/yyyy"),",")),
IF(ISBLANK(O2),"",CONCATENATE(N2," ",TEXT(O2,"mm/dd/yyyy"))))

as you have 365 textjoin
maybe this
=TEXTJOIN(",",TRUE,IF(A1:E1>0,TEXT(A1:E1,"dd/mm/yy"),""))

Originally Posted by etaf

as you have 365 textjoin
maybe this
=TEXTJOIN(",",TRUE,IF(A1:E1>0,TEXT(A1:E1,"dd/mm/yy"),""))

This is better than mine.