ExcelBanter - Calendar

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calendar (https://www.excelbanter.com/excel-worksheet-functions/27549-calendar.html)

PaolaAndrea

Calendar

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

Bob Phillips

=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

All times are GMT +1. The time now is 04:09 PM.