Results 1 to 4 of 4

Thread: Nine Month-End Periods
Thanks Thanks: 0 Likes Likes: 0

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

    Default Nine Month-End Periods

    Hi all!

    I need your help to calculate 9 Month periods gap between dates (months March, December, September and June in any order)

    Just like week/month/quarter/half year/year end.

    I need that for nine month period.

    For eg. If I find June-end date first from the date list then March should appear next.

    Or if September-end date is selected then June should appear...and so on.

    And applying it to the whole date list.

    Can anyone help me on this?

    Your suggestion would be highly appreciated.

    Thanks

  2. #2
    Board Regular steve the fish's Avatar
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,650
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Nine Month-End Periods

    Hi. This is too vague to be able to answer. Give more details on the set up and what you require.

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

    Default Re: Nine Month-End Periods

    Date Monthly Weekly Quarterly Half Yearly Fortnightly
    05/01/1998 1 2 1 1 1
    06/01/1998 1 2 1 1 1
    07/01/1998 1 2 1 1 1
    08/01/1998 1 2 1 1 1
    09/01/1998 1 2 2 09/01/1998 1 1 1
    12/01/1998 1 3 1 1 1
    13/01/1998 1 3 1 1 1
    14/01/1998 1 3 1 1 1
    15/01/1998 1 3 1 1 1 1 15/01/1998
    16/01/1998 1 3 3 16/01/1998 1 1 2
    19/01/1998 1 4 1 1 2
    20/01/1998 1 4 1 1 2
    21/01/1998 1 4 1 1 2
    22/01/1998 1 4 1 1 2
    23/01/1998 1 4 4 23/01/1998 1 1 2
    27/01/1998 1 5 1 1 2
    28/01/1998 1 5 1 1 2
    29/01/1998 1 1 29/01/1998 5 5 29/01/1998 1 1 2 2 29/01/1998
    02/02/1998 2 6 1 1 3
    03/02/1998 2 6 1 1 3
    04/02/1998 2 6 1 1 3
    05/02/1998 2 6 1 1 3
    06/02/1998 2 6 6 06/02/1998 1 1 3
    09/02/1998 2 7 1 1 3
    10/02/1998 2 7 1 1 3
    11/02/1998 2 7 1 1 3
    12/02/1998 2 7 1 1 3
    13/02/1998 2 7 7 13/02/1998 1 1 3 3 13/02/1998


    This is the way I did to break down the date list across different time series, I do not know how to do it for nine months

    I hope it will clear the air

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

    Default Re: Nine Month-End Periods

    Hi all!

    can anyone help me on this?

Some videos you may like

User Tag List

Tags for this Thread

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
  •