Excel 2016
A B 1 Name Value 2 Start Date 01/08/2019 3 End Date 29/02/2020 4 Project Id 2339731 [br /]
Worksheet Formulas
Cell Formula B3 =EOMONTH([color="Blue"]B2,6[/font])
J K L 6=TEXTJOIN(",",1,IF($C$6:$C$31=I6,$B$6:$B$31,"")) =VLOOKUP(I6,C: D,2,0) =SUBSTITUTE(TEXTJOIN("/",1,IF(($C$6:$C$31=I6),$D$6:$G$31,"")),"//","")