Naming custom date ranges

[seeker123]

Hi every one,

I have a large database with 10 years of data
I want to extract monthly data from it but the problem is that my monthly period starts at 9th of every month and ends at 8th of next month . I want to have a column that shows which month is the line in (my custom month) how can I do that?


For example I have something like column A and want to have column B
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]10-Jul-17[/TD]
[TD]Jul-17[/TD]
[/TR]
[TR]
[TD]7-Aug-17[/TD]
[TD]Jul-17[/TD]
[/TR]
[TR]
[TD]5-Jul-17[/TD]
[TD]Jun-17[/TD]
[/TR]
[TR]
[TD]3-Mar-17[/TD]
[TD]Feb-17[/TD]
[/TR]
</tbody>[/TABLE]
Thanks a lot

 

[frank_AL]

seeker,

Enter this formula in cell B2 then copy down.

=IF(DAY(A2)>9,TEXT(A2,"mmm")&"-"&TEXT(A2,"yy"),TEXT((A2)-28,"mmm")&"-"&TEXT(A2,"yy"))

 

[seeker123]

Frank,
Thank you for your reply it worked perfectly.