1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Date formula in header?

Discussion in 'Business Applications' started by AR1Redneck, Aug 10, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. AR1Redneck

    AR1Redneck Thread Starter

    Joined:
    Dec 13, 2002
    Messages:
    206
    Is it possible to use the date formula, =TODAY(), in the custom header and footer option. I cant get it to work but thought maybe there was a different way, TIA
     
  2. Ca1Ga1

    Ca1Ga1

    Joined:
    Jul 30, 2003
    Messages:
    79
    What program are you using?
     
  3. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    For Excel, in Custom Header, click the Date button.

    [​IMG]
     

    Attached Files:

  4. AR1Redneck

    AR1Redneck Thread Starter

    Joined:
    Dec 13, 2002
    Messages:
    206
    Thanks Randy, one more question is there a way to get it to say Monday, August 8, 2003???
     
  5. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    I tried posting this last night, but Mike had started his upgrades to the site . . .

    OK, not normally, but using VBA, you can put the value of a cell into the header.

    Take a look at Chip Pearson's explanation of it.
    This should take the value of Cell B5 on Sheet2 and put it in the header. that way, you can just set the Today code in B5 and format the Cell to include the day and date.
     
  6. RandyG

    RandyG

    Joined:
    Jun 26, 2000
    Messages:
    7,762
    Print Preview will show you if it worked or not!;):D


    Good call O and O. I sometimes forget the easy way of doing things, and that might work for Redneck!
     
  7. AR1Redneck

    AR1Redneck Thread Starter

    Joined:
    Dec 13, 2002
    Messages:
    206
    Thanks guys it worked perfectly.....thanks alot
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/154282

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice