mistatasty
New Member
- Joined
- Jul 21, 2021
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
Hi,
I have a start and end date for a performance period in cell b5 and b6, respectively. Below that, I would like in row 25 all of the months in that period to auto populate. So if 1/1/20 was entered in cell b5 as the start date and 1/1/21 was entered in cell b6 as the end date, row 25 starting in column e would auto fill the months jan 20, feb 20, mar 20.... all the way to jan 21. Ideally when you expand or contract the end starting or end dates in b5 and b6, row 25 would also add or contract the dates. Any way to do this? Thanks
I have a start and end date for a performance period in cell b5 and b6, respectively. Below that, I would like in row 25 all of the months in that period to auto populate. So if 1/1/20 was entered in cell b5 as the start date and 1/1/21 was entered in cell b6 as the end date, row 25 starting in column e would auto fill the months jan 20, feb 20, mar 20.... all the way to jan 21. Ideally when you expand or contract the end starting or end dates in b5 and b6, row 25 would also add or contract the dates. Any way to do this? Thanks