Shweta
Well-known Member
- Joined
- Jun 5, 2011
- Messages
- 514
Hello All,
I have a data validation list for all the months from January to December. I want to assign quarters to my months based on the selection in the validation list.
For example, If "November (11)" is selected in the validation list, Q1 should be May-July and Q2 should be Aug-Oct. And for rest of the period, I want month itself.
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Above is the table for what exactly I want.
Please help with an appropriate formula or vba code.
Thanks in advance!
Regards,
Shweta Jain
I have a data validation list for all the months from January to December. I want to assign quarters to my months based on the selection in the validation list.
For example, If "November (11)" is selected in the validation list, Q1 should be May-July and Q2 should be Aug-Oct. And for rest of the period, I want month itself.
Month | Quarter |
1 | q1 |
2 | q2 |
3 | q2 |
4 | q2 |
5 | may |
6 | jun |
7 | jul |
8 | aug |
9 | sep |
10 | oct |
11 | q1 |
12 | q1 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Above is the table for what exactly I want.
Please help with an appropriate formula or vba code.
Thanks in advance!
Regards,
Shweta Jain