+ Reply to Thread
Results 1 to 3 of 3

Month and Year

  1. #1
    Registered User
    Join Date
    01-28-2007
    Posts
    12

    Month and Year

    I am stuck with month and year that i want to put on my worksheet. I am using excel 2000. My question is, i would like a format of Month and year on my worksheet. FOr example, if today is January 31, 2007, and it will show on my worksheet as "January 2007" and tomorrow will be February 1, 2007 and my spreadsheet will automatically display "February, 2007" when i open my spreadsheet. I know ms word can do that but I am not sure excel can do the same. If anyone know how to do it, please let me know and i am very appreciated.

    Thanks

    hoachen

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Try this formula

    =TEXT(TODAY,"mmmm yyyy")

    or

    =TODAY()

    and format cell as mmmm yyyy

  3. #3
    Registered User
    Join Date
    01-28-2007
    Posts
    12
    thank you very much, it seem to works, will wait till february see it will change or not. THanks again

    cheer
    hoachen


    Quote Originally Posted by daddylonglegs
    Try this formula

    =TEXT(TODAY,"mmmm yyyy")

    or

    =TODAY()

    and format cell as mmmm yyyy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1