Removing Extra columns after the end of the month,

MuhammadFarooque - Jan 24, 2018 at 02:25 AM
 MuhammadFarooque - Jan 26, 2018 at 02:38 AM
Be Happy,
i want to ask you that my company's month starts from 23rd and ends on 22nd, so how the extra columns can be removed automatically (by applying any command/formula)in the month of February, because after 28th Feb extra three columns are shown in excel sheet. I am working with excel 2013.

2 replies

Blocked Profile
Jan 24, 2018 at 01:51 PM
Drag your cursor across the three columns, and right click. Select DELETE!
Blocked Profile
Jan 25, 2018 at 04:48 PM
So, I just hit the delete button? Do I need to highlight what I want to delete?
Jan 26, 2018 at 02:38 AM
Hello, Be Happy.
I mean to say that 23rd Dec is starting date, and 22nd Jan is the closing date of the company's 1st month. there would be 31 columns in total 23rd to 22 Jan in excel sheet.
this is right, OK.
Now in the Month of Jan -Feb 2018 , There should be only 28 columns, and three columns should be hidden automatically by formatting/using any formula or command.
And when i Change the month of March-April there should automatically be 31 columns.
so i want to know the specific formatting for this issue.