I have data flowing into Excel from two different Access queries. The first query lists all of my widget #s in column A. The 2nd query lists the first date of data that is available in the data set. I have this date query flowing into a separate tab (cell F3 on the separate tab) This date will roll over every week. In my original Excel tab, I want the header in column B to be that date, then the header in column C to be that date +7 days and so on so I have 24 weeks of dates as headers.

I then plan to use Index-Match formula in the remainder of the table using the widget# in column A and the date header in row 1 to calculate additional data from my other tabs which have pivot tables in this widget#/date header format.

However - when I set B1 =SelectTab!F3 it converts the column to tie it to the table data in A1, but the header switches to 1/0/1900 and the formula is gone. I cannot use this in my Index-Match query to get my data since it doesn't match.

If I "undo" the table auto expansion, I lose the header feature.

The date that should be populating is 4/9/2017

Changing the "format" of the cell does not help.

Any Advice?