AnsweredAssumed Answered

Week number calculation

Question asked by tomo17 on Dec 13, 2013
Latest reply on Dec 15, 2013 by tomo17


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