Hi there,
I am a teacher at a high school and am currently creating an Excel workbook to record students who need learning adjustments made.
On the table I have various columns of data, with student names listed in column B with their CURRENT year level in column A.
I’m not sure this is possible, but ideally I would like the year group (be it 7, 8, 9, 10, 11 or 12) to automatically change to the next value up at round the 7th November every year. This would save me or someone else going in and updating all the students year groups to the next year (i.e. On November 7th each year, all student names assigned as year “7” would change to show “8”; all year “8” values would change to “9”.
Obviously this could be managed relatively quickly manually or with a macro, but it would be great it it worked by itself.
I tried creating a column showing the =today() function and then tried to build conditional formatting equation on the Year Level column in column A, but I am not skilled in that particular area so bombed out pretty quickly.
Would anyone have any ideas about how to achieve the outcome I am desiring?
Thank you!
Jess
I am a teacher at a high school and am currently creating an Excel workbook to record students who need learning adjustments made.
On the table I have various columns of data, with student names listed in column B with their CURRENT year level in column A.
I’m not sure this is possible, but ideally I would like the year group (be it 7, 8, 9, 10, 11 or 12) to automatically change to the next value up at round the 7th November every year. This would save me or someone else going in and updating all the students year groups to the next year (i.e. On November 7th each year, all student names assigned as year “7” would change to show “8”; all year “8” values would change to “9”.
Obviously this could be managed relatively quickly manually or with a macro, but it would be great it it worked by itself.
I tried creating a column showing the =today() function and then tried to build conditional formatting equation on the Year Level column in column A, but I am not skilled in that particular area so bombed out pretty quickly.
Would anyone have any ideas about how to achieve the outcome I am desiring?
Thank you!
Jess