Had wonderful help with Concatenate and working with dates and formula used a range that was simple a1:f1 - However now been presented with same data but columns added in between A:F with data ( in red on new sheet ) that cannot be carried over . Do I need an individual range built into formula to capture the dates only or can something be built into formula to ignore non date cells ?
Bookmarks