Increment count of working day for month
Posted: Tue Jun 23, 2009 4:14 am
Hi all,
I have a requirement to calculate the incremental working day for the month. An example like below
Cal_Date Day Col1 Col2
01/01/09 Thu N 0
02/01/09 Fri Y 1
03/01/09 Sat N 1
04/01/09 Sun N 1
05/01/09 Mon Y 2
06/01/09 Tue Y 3
07/01/09 Wed Y 4
08/01/09 Thu Y 5
09/01/09 Fri Y 6
10/01/09 Sat N 6
.
.
.
30/01/09 Fri Y 21
31/01/09 Sat N 21
01/02/09 Sun N 0
02/02/09 Mon Y 1
03/02/09 Tue Y 2
.
.
.
Col1 is the work day indicator and Col2 is the incremental count of work day for month.
I have try different means to calculate Col2 but in vain. Has anyone done this before? Appreciate any ideas if you have. Tks
I have a requirement to calculate the incremental working day for the month. An example like below
Cal_Date Day Col1 Col2
01/01/09 Thu N 0
02/01/09 Fri Y 1
03/01/09 Sat N 1
04/01/09 Sun N 1
05/01/09 Mon Y 2
06/01/09 Tue Y 3
07/01/09 Wed Y 4
08/01/09 Thu Y 5
09/01/09 Fri Y 6
10/01/09 Sat N 6
.
.
.
30/01/09 Fri Y 21
31/01/09 Sat N 21
01/02/09 Sun N 0
02/02/09 Mon Y 1
03/02/09 Tue Y 2
.
.
.
Col1 is the work day indicator and Col2 is the incremental count of work day for month.
I have try different means to calculate Col2 but in vain. Has anyone done this before? Appreciate any ideas if you have. Tks