Related:
- Removing Extra columns after the end of the month,
- Display two columns in data validation list but return only one - Guide
- Removing redirect - Guide
- Month calculator - Download - Calculators
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
- Tweetdeck larger columns - Guide
2 responses
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.
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.
Jan 25, 2018 at 04:48 PM