-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to change month After select Dropdown list ???
- Thread starter krunal123
- Start date
-
- Tags
- #condition formatting #conditional formatting #excel #excel #comparison #excel #error #excel #formula #confused #excel #minimum #index #excel question #excel tutorial #formulahelp #pivot table #pivot table#fiilter #pivot tables #tables #sumif #indirect #index #vba #excel #if formula #explaination
jtakw
Well-known Member
- Joined
- Jun 29, 2014
- Messages
- 7,245
- Office Version
- 2016
- Platform
- Windows
Hi,
Your column reference in OP is H, but different in Post # 5, so adjust accordingly:
Your column reference in OP is H, but different in Post # 5, so adjust accordingly:
| Book3.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | H | ||||||||
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | march | |||||||||
| 65 | 3/1/2022 | |||||||||
| 66 | 3/2/2022 | |||||||||
| 67 | 3/3/2022 | |||||||||
| 68 | 3/4/2022 | |||||||||
| 69 | 3/5/2022 | |||||||||
| 70 | 3/6/2022 | |||||||||
| 71 | 3/7/2022 | |||||||||
| 72 | 3/8/2022 | |||||||||
| 73 | 3/9/2022 | |||||||||
| 74 | 3/10/2022 | |||||||||
| 75 | 3/11/2022 | |||||||||
| 76 | 3/12/2022 | |||||||||
| 77 | 3/13/2022 | |||||||||
| 78 | 3/14/2022 | |||||||||
| 79 | 3/15/2022 | |||||||||
| 80 | 3/16/2022 | |||||||||
Sheet22 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B65 | B65 | =(1&H3)+0 |
| B66:B80 | B66 | =B65+1 |
Upvote
0
Similar threads
- Question
- Solved
