2 Replies Latest reply on Dec 15, 2013 5:27 PM by tomo17

    Week number calculation

    tomo17

      Title

      Week number calculation

      Post

           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