Excel Header Question

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

  1. JC

    JC Guest

    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. Advertisements

  2. JC

    Steve n Debs Guest

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

    Steve n Debs, Jan 13, 2006
    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
    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.