Results 1 to 3 of 3

Thread: month formula

  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Unanswered: month formula

    hi
    what formula would i use so that when i go on to a sheet the month will update to the current one automatically

  2. #2
    Join Date
    Jan 2004
    Location
    Newcastle UK
    Posts
    10
    So you've got a cell with the month in?

    I would use something like a vlookup based on :

    =vlookup(month(now()),month_table,2,false)

    where month_table is:

    1 January
    2 February
    3 March
    etc

    If ya know what i mean ...


  3. #3
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Try =NOW()

    Format Cells-->Date-->Month Format, which will give you eg. "February-04"

    For month only, use: =TEXT(NOW(),"MMMM")

    Hope that helps,

    Smitty

Posting Permissions

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