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

1. ## 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. ## 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. ## 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. ## Re: Nine Month-End Periods

Hi all!

can anyone help me on this?