I am trying to create a link that changes with the date entered in C1
Original Link =‘file:///C:/2018Document.ods’#$heet1.A1
Attempted Link =‘file:///C:/’ & C1 & ‘Document.ods’#$heet1.A1
but that is converted to =‘file:///C:’ & C1 & ‘file:///C:Document.ods’#$Sheet1.A1
Any help is appreciated.