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

Column A	Column B
10-Jul-17	Jul-17
7-Aug-17	Jul-17
5-Jul-17	Jun-17
3-Mar-17	Feb-17

<tbody>
</tbody>

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.