=indirect("'" & text(today(),"mmddyy") & "'!L1192")
or maybe:
=indirect("'" & text(today()-1,"mmddyy") & "'!L1192")
If you wanted to use yesterday's date.

pm wrote:

We have a daily file with several worksheets....in one of the tabs I link
specific fields to another tab that uses the current date as the name -
=+'022808'!L1192 ......so the tab name changes daily to reflect todays date.
My question is, how can I link to a tab that has a different name every day?
Is there a formula that I can use instead of +'031008'!L1192?

--

Dave Peterson