Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formula to yield number representing preceding month

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A1 contains function TODAY(). I would like a formula in A2 which yield the number of the month preceding, for instance if today's date is May 9, the formula in A2 would yield 4. If today's date is any day in June, the formula in A2 would yield 5, and so on. I will need to be able to divide other sets of numbers by the number in A2.
    Any help will be appreciated.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =MONTH(EDATE(A1,-1))

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,486
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default



    =MONTH(A1)-1

    format as general or number

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-09 08:25, Dave Patton wrote:


    =MONTH(A1)-1

    format as general or number
    ...and if A1 contains 1/1/2002?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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