Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: fiscal month formula

  1. #1
    New Member
    Join Date
    Jun 2011
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default fiscal month formula

    this may be a dumb one.

    fiscal year starts in june.

    want to return fiscal month number.

    convert june from 6 to 1, july from 7 to 2, etc... without an IF in there (possible?).

    thanks,

    nuk

  2. #2
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Boston, Massachusetts
    Posts
    2,284
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: fiscal month formula

    With
    A1: a date

    This regular formula returns the Fiscal Month Number of that date
    Code:
    B1: =MONTH(EDATE(A1,7))
    Does that help?
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (2006 - 2015)
    Using: Excel 2013 & 2016

  3. #3
    New Member
    Join Date
    Jun 2011
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: fiscal month formula

    that's perfect!

    thanks for the help ron!

  4. #4
    New Member
    Join Date
    Sep 2006
    Location
    San Diego, CA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: fiscal month formula

    I have a similar request, except I need the date to convert into a YYYYMM format. For our company 7/1/2013 = 201401; 6/30/2014 = 201412.

  5. #5
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Boston, Massachusetts
    Posts
    2,284
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: fiscal month formula

    This is a really old thread...I think next time, you should start a new thread (and reference any olds that are pertinent )
    Meanwhile:
    Does this help?
    =TEXT(EDATE(A1,6),"YYYYMM")
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (2006 - 2015)
    Using: Excel 2013 & 2016

  6. #6
    New Member
    Join Date
    Sep 2006
    Location
    San Diego, CA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: fiscal month formula

    Hi Ron,

    That's elegant in its simplicity and powerful in its effectiveness. It works perfectly. Thanks also for the tip on old posts.

    Gary
    Excel 2010

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
  •