Week number calculation
I have a calendar that is based on one that philmodjunk has previously posted and I am trying to modify it for my purposes in a school environment. What i am hoping to do is to have each week in the calendar given a number based on a starting date to indicate the week of a term. Given that we have 4 terms I am thinking that I would need to have a calculation that compares the Monday date to the term's start date and then allocates the week number but I am stuck in how I would actually put this calculation together. Do I set up a calculation that works out the days form the start and then divide by 7 or is there a much more elegant way?
Many thanks for any suggestions