Calendar Table - Change in Month - mid of every month

[Anonymous]

Hi,

I am using calendar table which I have downloaded and was prepared by Avi Singh @avisingh

I would like to have a different column with the below requirement for each month due to certain reporting structures in the organization.

Example

15th June to 15th July - will be June 2022

15th July to 15th August - will be August 2022

This keeps going for each year and each month.

Can someone help

[ryan_mayu]

@Anonymous 

pls see the attachment below

[Anonymous]

@ryan_mayu-

1. The sorting doesnt work out. I tried by date, it says Sort error. Below are the screen shots. Could you help me with it

2. Also, how can I add a space between the Month and Year. Being a beginner tough to figure it out

[ryan_mayu · Accepted solution]

@Anonymous 

pls see the attachment below