I've looked a lot but cannot find solution to match my query.
I get data sent to me each week, but when converted to excel, the dates end up being this format nn/nn.
So for instance 29th April would be 29/04, but my formulas don't see 29/04 as a date.
Is there a way I can convert this string to a date using vba? The dates are all in row 1 by the way.