NotKentClark
New Member
- Joined
- Feb 4, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
- MacOS
I have a spreadsheet I'm working on where I need to track daily sales, that connects with a commission structure. The current table I have shows all days of the month (29 days this month), I have created a Data Validation drop-down list with other months of this year.
Is there a way, that when I select a different month, say March I can have the cells with the February dates automatically adjust to March?
Any help would be appreciated!
Is there a way, that when I select a different month, say March I can have the cells with the February dates automatically adjust to March?
February | March |
Monday, February 3rd, 2020 | Monday, March 2nd, 2020 |
Tuesday, February 3rd, 2020 | Tuesday, March 3rd, 2020 |
Wednesday, February 3rd, 2020 | Wednesday, March 4th, 2020 |
Etc. | Etc. |
Any help would be appreciated!