I'm trying to make a school register. on one sheet there will be 52 weeks worth of attendance.
at the top of each week i want to write WEEK 1, WEEK 2, WEEK 3 ETC.
instead of having to type Week 2, Week 3.... (i.e. having to change the number 52 times.. can i do a formula like:
="Week" +1
so that the next cell will be "1 more" than its previous one, along with the word WEEK appearing each time?
thanks
Bookmarks