spacer
Yehuda Shiran February 17, 2001
Computing the Current Work Week
Tips: February 2001

Yehuda Shiran, Ph.D.
Doc JavaScript

Developer News
OpenOffice 3.2 Lands Amid Critical Changes
Red Hat, IBM Firmly in KVM Virtualization Camp
Red Hat Talks Up Open Source Cloud Plans

In many organizations, the calendar year is divided into Work Weeks, usually abbreviated as wwxy. The first week of the year is ww01, the second is ww02, and so on. The last week of the year is usually ww52 or ww53. A week starts on Sunday and ends on the following Saturday. In order to compute the current work week, we need to know how many days passed since Sunday of ww01, divide by 7, and round upwards. We can compute the number of days since Sunday of ww01 by adding the following:

  • Days in ww01 before January 1. This is actually the day of the week for January 1. If January 1 is 2 (Tuesday), for example, there are two days in ww01 that belong to the previous year (Sunday and Monday).
  • Days in all months prior to current month. If today is February, for example, previous months include just January.
  • Days in the current month that have passed. This is actually the current date.

To compute the day of the week of January 1, we first create an instance date for January 1 (same year as today):

var newYearDayInstance = new Date(year, 0, 1); //instance of the date for January 1

And then get the day of the week:

var newYearDayOfWeek = newYearDayInstance.getDay(); //day of the week for January 1. 0 is Sunday

We then initialize the number of days passed since Sunday of ww01:

var daysUntilToday = newYearDayOfWeek; 

And then add all previous months:

for (var j = 0; j <= month - 1; j++) { //count days in all previous months
  daysUntilToday += getDays(j, year);
}

And finally, adding the number of days passed this month:

daysUntilToday += date;

We return the round-up number of the weekly count:

return Math.ceil(daysUntilToday/7);

We find the current work week, by calling getWorkWeek(); Here is the full listing of the methods:

<SCRIPT LANGUAGE="JavaScript">
function getDays(month, year) {
  // create array to hold number of days in each month
  var ar = new Array(12);
  ar[0] = 31; // January
  ar[1] = (year % 4 == 0) ? 29 : 28; // February
  ar[2] = 31; // March
  ar[3] = 30; // April
  ar[4] = 31; // May
  ar[5] = 30; // June
  ar[6] = 31; // July
  ar[7] = 31; // August
  ar[8] = 30; // September
  ar[9] = 31; // October
  ar[10] = 30; // November
  ar[11] = 31; // December

  // return number of days in the specified month (parameter)
  return ar[month];
}

function getWorkWeek() {
  var now = new Date();
  var year = now.getFullYear();
  var month = now.getMonth();
  var date = now.getDate();
  now = null; // release memory

  var newYearDayInstance = new Date(year, 0, 1); //instance of the date for January 1
  var newYearDayOfWeek = newYearDayInstance.getDay(); //day of the week for January 1. 0 is Sunday
  var daysUntilToday = newYearDayOfWeek; //days before January 1 in ww01
  
  for (var j = 0; j <= month - 1; j++) { //count days in all previous months
    daysUntilToday += getDays(j, year);
  }
  daysUntilToday += date; //add days in current month
  return Math.ceil(daysUntilToday/7);
}
 
</SCRIPT>

Update (posted February 24, 2004)

The following information comes from Dave Matheson, a reader in Oslo, Norway.

The working week script at http://webreference.com/js/tips/010217.html works fine for US users. However the ISO standard (used in Europe) has the working week starting on a Monday. Therefore today (Sunday, Feb. 22nd 2004) would be working week 9 (in the US and per the script you have published), but week 8 in Europe (ISO standard).

To have the working week starting on a Monday (Europe / ISO standard) as opposed to Sunday (USA) the script needs to be altered as follows:

Change the variable [within the function getWorkWeek()] from:
"var date = now.getDate();" to
"var date = now.getDate()-1;"
(lies in the function "function getWorkWeek()")

This has been checked across a variety of dates and seems to work fine - though I am only a novice when it comes to Javascripts.


People who read this tip also read these tips:

Look for similar tips by subject:


The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers

webref The latest from WebReference.com Browse >
Search Engine Optimization: Selecting and Embedding Keywords · Are Google's Language Translation Web Services Ready for Prime Time? · Installing and Using Meeplace, the Business Review CMS
Sitemap · Experts · Tools · Services · Email a Colleague · Contact FREE Newsletters 
 The latest from internet.com
IBM DB2 10 for z/OS: Justifying the Upgrade · Living La Vida Colo: Choosing the Right Colocation Facility · FTC Concerns over Social Media Privacy Linger