Since your data is in Excel, your best bet is to use the Tableau plugin:
And reshape your data. Dates running horizontal in columns doesn't work very well in Tableau. Once you're got all your dates in a single column then you can use TODAY() to easily call up that day's target.
I have no idea about your OBIEE question, you really should ask it as a separate question.