Bi-Weekly date problem :(

[Ticcer]

In C1 I have the beginning date of the first pay period an employee commenced work, e.g. 18/09/2015. In C2 I have the end date of that first pay period, e.g. 01/10/2015. I thought these would be useful as formula helpers.


The records begin at row 6, with the date the employee began working at C6, e.g. 28/09/2015, C7 = 29/09/2015, C8 = 30/09/2015, C9 = 01/10/2015 and so on. as shown below.

I'd like a formula in the I column (Pay Period) to check the date in the C column (Date Worked) and determine the pay period number for the employee, e.g. all dates in column C between (and including) 18/09/2015 and 01/10/2015 should return a '1' result in column I (even though the employee began after the 18/09/2015). All dates in column C between (and including) 02/10/2015 and 15/10/2015 should return the number '2' to the formula in column I, and so on.

Basically, as shown below, the number in column I increments by 1 every 14 days, but the employee started in the middle of the first pay period, so there are only 4 cells in column I that have the number 1.


I can't figure out for the life of me how to account for that part period in a formula.


Sample data set is below The "Store" column is B

[TABLE="width: 750"]
<tbody>[TR]
[TD]Store[/TD]
[TD]Date Worked[/TD]
[TD]Day Worked[/TD]
[TD]Time Start[/TD]
[TD]Time Finish[/TD]
[TD]Unpaid Break[/TD]
[TD]Hours Worked[/TD]
[TD]Pay Period[/TD]
[TD]Pay Day[/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]28/09/2015[/TD]
[TD]Monday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]29/09/2015[/TD]
[TD]Tuesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]30/09/2015[/TD]
[TD]Wednesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]1/10/2015[/TD]
[TD]Thursday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]2/10/2015[/TD]
[TD]Friday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]3/10/2015[/TD]
[TD]Saturday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]4/10/2015[/TD]
[TD]Sunday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]5/10/2015[/TD]
[TD]Monday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]6/10/2015[/TD]
[TD]Tuesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]7/10/2015[/TD]
[TD]Wednesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]8/10/2015[/TD]
[TD]Thursday[/TD]
[TD]9:00 AM[/TD]
[TD]5:00 PM[/TD]
[TD]0.5[/TD]
[TD]7.5[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]9/10/2015[/TD]
[TD]Friday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]10/10/2015[/TD]
[TD]Saturday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]11/10/2015[/TD]
[TD]Sunday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]12/10/2015[/TD]
[TD]Monday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]13/10/2015[/TD]
[TD]Tuesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]14/10/2015[/TD]
[TD]Wednesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]15/10/2015[/TD]
[TD]Thursday[/TD]
[TD]9:00 AM[/TD]
[TD]6:30 PM[/TD]
[TD]0.5[/TD]
[TD]9[/TD]
[TD]2[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]16/10/2015[/TD]
[TD]Friday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]17/10/2015[/TD]
[TD]Saturday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]18/10/2015[/TD]
[TD]Sunday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]19/10/2015[/TD]
[TD]Monday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]20/10/2015[/TD]
[TD]Tuesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]21/10/2015[/TD]
[TD]Wednesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]22/10/2015[/TD]
[TD]Thursday[/TD]
[TD]9:00 AM[/TD]
[TD]5:00 PM[/TD]
[TD]0.5[/TD]
[TD]7.5[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]23/10/2015[/TD]
[TD]Friday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]24/10/2015[/TD]
[TD]Saturday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day Off[/TD]
[TD]25/10/2015[/TD]
[TD]Sunday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]26/10/2015[/TD]
[TD]Monday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0.5[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]27/10/2015[/TD]
[TD]Tuesday[/TD]
[TD]Off[/TD]
[TD]Off[/TD]
[TD]0.5[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]28/10/2015[/TD]
[TD]Wednesday[/TD]
[TD]9:00 AM[/TD]
[TD]5:30 PM[/TD]
[TD]0.5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Store 1[/TD]
[TD]29/10/2015[/TD]
[TD]Thursday[/TD]
[TD]9:00 AM[/TD]
[TD]5:00 PM[/TD]
[TD]0.5[/TD]
[TD]7.5[/TD]
[TD]3[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]


Any help would be much appreciated as it's been a few years since I picked up Excel and I'm way rusty. Using Excel 2010.

 

[jtakw]

Hi,

This is one way.

I2 formula copied down, start date of 18/09/2015 hard coded in formula.
L2 formula copied down, start date in M2 used as reference in formula.

Book1
	B	C	D	E	F	G	H	I	J	K	L	M
1	Store	Date Worked	Day Worked	Time Start	Time Finish	Unpaid Break	Hours Worked	Pay Period	Pay Day		Pay Period	Start Date
2	Store 1	28/09/2015	Monday	9:00 AM	5:30 PM	0.5	8	1			1	18/09/2015
3	Store 1	29/09/2015	Tuesday	9:00 AM	5:30 PM	0.5	8	1			1
4	Day Off	30/09/2015	Wednesday	9:00 AM	5:30 PM	0.5	8	1			1
5	Store 1	01/10/2015	Thursday	9:00 AM	5:30 PM	0.5	8	1	Yes		1
6	Store 1	02/10/2015	Friday	9:00 AM	5:30 PM	0.5	8	2			2
7	Day Off	03/10/2015	Saturday	Off	Off	0		2			2
8	Day Off	04/10/2015	Sunday	Off	Off	0		2			2
9	Day Off	05/10/2015	Monday	9:00 AM	5:30 PM	0.5	8	2			2
10	Store 1	06/10/2015	Tuesday	9:00 AM	5:30 PM	0.5	8	2			2
11	Store 1	07/10/2015	Wednesday	9:00 AM	5:30 PM	0.5	8	2			2
12	Store 1	08/10/2015	Thursday	9:00 AM	5:00 PM	0.5	7.5	2			2
13	Store 1	09/10/2015	Friday	9:00 AM	5:30 PM	0.5	8	2			2
14	Store 1	10/10/2015	Saturday	Off	Off	0		2			2
15	Store 1	11/10/2015	Sunday	Off	Off	0		2			2
16	Day Off	12/10/2015	Monday	Off	Off	0		2			2
17	Store 1	13/10/2015	Tuesday	9:00 AM	5:30 PM	0.5	8	2			2
18	Store 1	14/10/2015	Wednesday	9:00 AM	5:30 PM	0.5	8	2			2
19	Store 1	15/10/2015	Thursday	9:00 AM	6:30 PM	0.5	9	2	Yes		2
20	Store 1	16/10/2015	Friday	9:00 AM	5:30 PM	0.5	8	3			3
21	Store 1	17/10/2015	Saturday	Off	Off	0		3			3
22	Store 1	18/10/2015	Sunday	Off	Off	0		3			3
23	Store 1	19/10/2015	Monday	9:00 AM	5:30 PM	0.5	8	3			3
24	Store 1	20/10/2015	Tuesday	9:00 AM	5:30 PM	0.5	8	3			3
25	Store 1	21/10/2015	Wednesday	9:00 AM	5:30 PM	0.5	8	3			3
26	Store 1	22/10/2015	Thursday	9:00 AM	5:00 PM	0.5	7.5	3			3
27	Store 1	23/10/2015	Friday	9:00 AM	5:30 PM	0.5	8	3			3
28	Day Off	24/10/2015	Saturday	Off	Off	0		3			3
29	Day Off	25/10/2015	Sunday	Off	Off	0		3			3
30	Store 1	26/10/2015	Monday	Off	Off	0.5		3			3
31	Store 1	27/10/2015	Tuesday	Off	Off	0.5		3			3
32	Store 1	28/10/2015	Wednesday	9:00 AM	5:30 PM	0.5	8	3			3
33	Store 1	29/10/2015	Thursday	9:00 AM	5:00 PM	0.5	7.5	3	Yes		3
Sheet126

Cell Formulas
Range	Formula
I2	=ROUNDUP((C2-DATE(2015,9,18)+1)/14,0)
L2	=ROUNDUP((C2-M$2+1)/14,0)

 

[Ticcer]

Thanks Jtakw. I'll give that a go when I get home. I don't mind the extra column... basically just want something that works lol. Cheers muchly.

T

 

[jtakw]

Thanks Jtakw. I'll give that a go when I get home. I don't mind the extra column... basically just want something that works lol. Cheers muchly.

T

No, No....There's no Extra Column, I'm giving you a Choice of hard-coding the Start Date in the formula OR using a Cell Reference that you can Change easily.

Just choose one or the other, Not both...

Let me know if you need more clarification.

 

[Ticcer]

No, No....There's no Extra Column, I'm giving you a Choice of hard-coding the Start Date in the formula OR using a Cell Reference that you can Change easily.

Just choose one or the other, Not both...

Let me know if you need more clarification.

Ah! I see. Sorry. didn't read it properly... too much going on at work lol.

Thanks for clarifying.

T

 

[Ticcer]

Modified it slightly to work without hard coding date with no extra column:

First row of data is 6 with first date at C6, Start Date is at C1

=ROUNDUP((C6-DATE(YEAR($C$1),MONTH($C$1),DAY($C$1))+1)/14,0)

Works well. Many thanks again.

T

 

[jtakw]

You're welcome, glad you got it working.

But I Never suggested an Extra Column. Thought you understood.

Also, you stated start date is 18/09/2015, C1 (may be you mean C2), is 28/09/2015

 

[Ticcer]

LOL, mate, I'm just a bit too slow on it today. I get it now. ~~feeling dunceified~~

 

[jtakw]

Modified it slightly to work without hard coding date

Start Date is at C1

=ROUNDUP((C6-DATE(YEAR($C$1),MONTH($C$1),DAY($C$1))+1)/14,0)

Works well. Many thanks again.

T

Just curious, if this version of the formula is working, why can't it just be:

=ROUNDUP((C6-$C$1+1)/14,0)

as I suggested in post #2 , L2 formula, Cell reference version?

 

[Ticcer]

Correct. I screwed up the dates. Start date is 28/9/2015 not 18/9/2015. So =ROUNDUP((C6-C$1+11)/14,0) works in column I

Excel 2010

	A	B	C	D	E	F	G	H	I
Pay Day	Store
Store 1
Store 1
Day Off
Store 1
Store 1
Day Off
Day Off
Day Off
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Day Off
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Store 1
Day Off
Day Off
Store 1
Store 1
Store 1
Store 1

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]First Pay Period Start[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28/09/2015[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]First Pay Period End[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1/10/2015[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]Date Worked[/TD]
[TD="align: center"]Day Worked[/TD]
[TD="align: center"]Time Start[/TD]
[TD="align: center"]Time Finish[/TD]
[TD="align: center"]Unpaid Break[/TD]
[TD="align: center"]Hours Worked[/TD]
[TD="align: center"]Pay Period[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"][/TD]

[TD="align: center"]28/09/2015[/TD]
[TD="align: center"]Monday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]7[/TD]
[TD="align: center"][/TD]

[TD="align: center"]29/09/2015[/TD]
[TD="align: center"]Tuesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"][/TD]

[TD="align: center"]30/09/2015[/TD]
[TD="align: center"]Wednesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Yes[/TD]

[TD="align: center"]1/10/2015[/TD]
[TD="align: center"]Thursday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]10[/TD]
[TD="align: center"][/TD]

[TD="align: center"]2/10/2015[/TD]
[TD="align: center"]Friday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"][/TD]

[TD="align: center"]3/10/2015[/TD]
[TD="align: center"]Saturday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"][/TD]

[TD="align: center"]4/10/2015[/TD]
[TD="align: center"]Sunday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]13[/TD]
[TD="align: center"][/TD]

[TD="align: center"]5/10/2015[/TD]
[TD="align: center"]Monday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]14[/TD]
[TD="align: center"][/TD]

[TD="align: center"]6/10/2015[/TD]
[TD="align: center"]Tuesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]15[/TD]
[TD="align: center"][/TD]

[TD="align: center"]7/10/2015[/TD]
[TD="align: center"]Wednesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]16[/TD]
[TD="align: center"][/TD]

[TD="align: center"]8/10/2015[/TD]
[TD="align: center"]Thursday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]7.5[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]17[/TD]
[TD="align: center"][/TD]

[TD="align: center"]9/10/2015[/TD]
[TD="align: center"]Friday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]18[/TD]
[TD="align: center"][/TD]

[TD="align: center"]10/10/2015[/TD]
[TD="align: center"]Saturday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]19[/TD]
[TD="align: center"][/TD]

[TD="align: center"]11/10/2015[/TD]
[TD="align: center"]Sunday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]20[/TD]
[TD="align: center"][/TD]

[TD="align: center"]12/10/2015[/TD]
[TD="align: center"]Monday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]21[/TD]
[TD="align: center"][/TD]

[TD="align: center"]13/10/2015[/TD]
[TD="align: center"]Tuesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]22[/TD]
[TD="align: center"][/TD]

[TD="align: center"]14/10/2015[/TD]
[TD="align: center"]Wednesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]23[/TD]
[TD="align: center"]Yes[/TD]

[TD="align: center"]15/10/2015[/TD]
[TD="align: center"]Thursday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]6:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]24[/TD]
[TD="align: center"][/TD]

[TD="align: center"]16/10/2015[/TD]
[TD="align: center"]Friday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]25[/TD]
[TD="align: center"][/TD]

[TD="align: center"]17/10/2015[/TD]
[TD="align: center"]Saturday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]26[/TD]
[TD="align: center"][/TD]

[TD="align: center"]18/10/2015[/TD]
[TD="align: center"]Sunday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]27[/TD]
[TD="align: center"][/TD]

[TD="align: center"]19/10/2015[/TD]
[TD="align: center"]Monday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]28[/TD]
[TD="align: center"][/TD]

[TD="align: center"]20/10/2015[/TD]
[TD="align: center"]Tuesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]29[/TD]
[TD="align: center"][/TD]

[TD="align: center"]21/10/2015[/TD]
[TD="align: center"]Wednesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]30[/TD]
[TD="align: center"][/TD]

[TD="align: center"]22/10/2015[/TD]
[TD="align: center"]Thursday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]7.5[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]31[/TD]
[TD="align: center"][/TD]

[TD="align: center"]23/10/2015[/TD]
[TD="align: center"]Friday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]32[/TD]
[TD="align: center"][/TD]

[TD="align: center"]24/10/2015[/TD]
[TD="align: center"]Saturday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]33[/TD]
[TD="align: center"][/TD]

[TD="align: center"]25/10/2015[/TD]
[TD="align: center"]Sunday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]34[/TD]
[TD="align: center"][/TD]

[TD="align: center"]26/10/2015[/TD]
[TD="align: center"]Monday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]35[/TD]
[TD="align: center"][/TD]

[TD="align: center"]27/10/2015[/TD]
[TD="align: center"]Tuesday[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]Off[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]36[/TD]
[TD="align: center"][/TD]

[TD="align: center"]28/10/2015[/TD]
[TD="align: center"]Wednesday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:30 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]37[/TD]
[TD="align: center"]Yes[/TD]

[TD="align: center"]29/10/2015[/TD]
[TD="align: center"]Thursday[/TD]
[TD="align: center"]9:00 AM[/TD]
[TD="align: center"]5:00 PM[/TD]
[TD="align: center"]0.5[/TD]
[TD="align: center"]7.5[/TD]
[TD="align: center"]3[/TD]

</tbody>

​