You could do this with a HYPERLINK function, where you would take the
current date from TODAY and turn it into an appropriate row number and jump
to there.

Give some details about how your sheet is laid out if you want more advice,
i.e where are the dates or weeks you mention?

Hope this helps.

Pete

"SophiaS" wrote in message
...
Hello,

I would like to create a formula that when I open the file it recognizes
the
date and moves the line to the appropriate date or week. I have see it
done
before but can't find any help