=TODAY()
=TODAY()+1
etc.

--
HTH

Bob Phillips

"PaolaAndrea" wrote in message
...
I have a worksheet with a two week look ahead calendar.
How can I have yesterday's date hide and have today's day listed
automatically plus have the next 10 days update automatically?

Thank you.

Sincerely,

PaolaAndrea