I have a spreadsheet that I use with my students in school. There is a column which shows which year group they are in (numbered from 1-6). Every September this increases by 1, i.e. from year 1 to year 2 etc. Is there a formula that will automatically change this for me, or do I need to write some VBA code to do this?
Thanks
Thanks