Excel Header Date

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!
2 answers Last reply
More about excel header date
  1. 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:
  2. 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!
Ask a new question

Read More

Document Excel Windows XP Apps