Excel - using text inside one cell to define column in formula

Hi, I have a spreadsheet with a load of passenger numbers, rows are the individual routes, columns are the dates. this is updated regularly as we proceed through the year. Not all dates are used, o...