Excel Header Question

Discussion in 'Computer Support' started by JC, Jan 13, 2006.

  1. JC

    JC Guest

    Hi,
    When I do monthly reports at work, the date on the header of my spreadsheet
    needs to be updated accordingly. How do I set it up so it states the
    current month in the header automatically ? I know I can set it so it will
    update to include the date, ("&[Date]"), but I only want the month.


    thanks in advance,
     
    JC, Jan 13, 2006
    #1
    1. Advertisements

  2. JC

    Steve n Debs Guest

    =MONTH(NOW()) will return the month in number format (1-12)

    HTH
     
    Steve n Debs, Jan 13, 2006
    #2
    1. Advertisements

  3. When someone opens your January 2006 report next month, wouldn't it then
    show as the February 2006 report?
     
    Blinky the Shark, Jan 13, 2006
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.