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
<tbody>
</tbody>Thanks a lot
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>
Last edited: