#1   Report Post  
PaolaAndrea
 
Posts: n/a
Default 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
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i set up a calendar in excel? Luxbrian Excel Discussion (Misc queries) 0 April 11th 05 05:54 PM
Where can I find a 2006 Business Calendar template? Cindy Charts and Charting in Excel 1 March 22nd 05 03:02 AM
Calendar and info for that date Jenn Excel Discussion (Misc queries) 0 January 5th 05 04:21 PM
Calendar 13 Periods 4 weeks each CHawk@Mcc Excel Discussion (Misc queries) 2 December 10th 04 04:27 PM
Weekly data into Calendar Weeks ExcelMonkey Excel Worksheet Functions 2 November 22nd 04 08:41 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"