JustPlainJef

Distinguished
Feb 20, 2001
23
0
18,560
Using Excel XP, I know one can insert the current date into the header of a document. What I would like to insert is tomorrow's date. Any thought? Something that would be easily (automatically) updated. Thanks!

What's a signature? Oh, those words that show up after all my comments? I don't need one of those!
 

camieabz

Distinguished
Jan 29, 2001
90
0
18,610
You can enter "=TODAY()+1" into a cell to make it show tomorrow's date, but if you try "&[date]+1" you just get the output "17/07/03+1" :smile:

Sounds like a VB issue. Sorry.

<b><font color=blue>~ <A HREF="http://forums.btvillarin.com/index.php?act=ST&f=41&t=324&s=58e94ba84a16bedfebbf0f416d5bac48" target="_new">System Specs</A> ~<font color=blue></b> :wink:
 

JustPlainJef

Distinguished
Feb 20, 2001
23
0
18,560
Yeah, I tried that, along with &[Tomorrow] and &[date+1] but none of them worked. Maybe I will tell them to take it out of the header and put it in the WS.

What's a signature? Oh, those words that show up after all my comments? I don't need one of those!