Hi
I need to be able to add the year to a month based on the current academic year in relation to the current date.
On the attached, each month, in order for the academic year starting in August, is listed. What I want is to create a formula in each of the cells with the month in, to add the correct year.
So, for example, A2:A6 should show the month with the year 2014. A7:A14 the year should be 2015 against each month.
I know I can just add the year but I want to "future-proof" this so I don't have to manually change the years every time a new academic year starts.
Can anyone please help with a solution? (hopefully I've explained clearly, if not let me know)
Bookmarks