Week To Date and MTD Calculations

[bolwahnn]

Hi All,
I need some help on a calculation - I have a table full of data that I'm building a report on - This report will have Previous Day, Week To Date, and Month To Date calculation. How do I create calcs in the report so that it automatically pulls the Week to Date and Month to date calcs?

For example: say today was Sunday August 18th....My previous day data would show data from the 17th, My week to date would show total from Monday the 12th through Saturday the 17th, and my Month to date would show the 1st through the 17th (the 18th would have no data).

This is what my table data looks like.... where "#of clients met goal"/"total clients" = "PD% achieved"....Looking to pull week to date and month to date "PD % acheived" from this table.
[TABLE="width: 415"]
<TBODY>[TR]
[TD]Date</SPAN>[/TD]
[TD]Total Clients</SPAN>[/TD]
[TD]# of Clients that Met Goal</SPAN>[/TD]
[TD]PD % Achieved</SPAN>[/TD]
[/TR]
[TR]
[TD]1-Aug</SPAN>[/TD]
[TD]164</SPAN>[/TD]
[TD]152</SPAN>[/TD]
[TD]93%</SPAN>[/TD]
[/TR]
[TR]
[TD]2-Aug</SPAN>[/TD]
[TD]164</SPAN>[/TD]
[TD]140</SPAN>[/TD]
[TD]85%</SPAN>[/TD]
[/TR]
[TR]
[TD]3-Aug</SPAN>[/TD]
[TD]164</SPAN>[/TD]
[TD]90</SPAN>[/TD]
[TD]55%</SPAN>[/TD]
[/TR]
[TR]
[TD]4-Aug</SPAN>[/TD]
[TD]164</SPAN>[/TD]
[TD]41</SPAN>[/TD]
[TD]25%</SPAN>[/TD]
[/TR]
[TR]
[TD]5-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]123</SPAN>[/TD]
[TD]75%</SPAN>[/TD]
[/TR]
[TR]
[TD]6-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]123</SPAN>[/TD]
[TD]75%</SPAN>[/TD]
[/TR]
[TR]
[TD]7-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]132</SPAN>[/TD]
[TD]81%</SPAN>[/TD]
[/TR]
[TR]
[TD]8-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]141</SPAN>[/TD]
[TD]87%</SPAN>[/TD]
[/TR]
[TR]
[TD]9-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]141</SPAN>[/TD]
[TD]87%</SPAN>[/TD]
[/TR]
[TR]
[TD]10-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]83</SPAN>[/TD]
[TD]51%</SPAN>[/TD]
[/TR]
[TR]
[TD]11-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]43</SPAN>[/TD]
[TD]26%</SPAN>[/TD]
[/TR]
[TR]
[TD]12-Aug</SPAN>[/TD]
[TD]163</SPAN>[/TD]
[TD]130</SPAN>[/TD]
[TD]80%</SPAN>[/TD]
[/TR]
[TR]
[TD]13-Aug</SPAN>[/TD]
[TD]168</SPAN>[/TD]
[TD]143</SPAN>[/TD]
[TD]85%</SPAN>[/TD]
[/TR]
[TR]
[TD]14-Aug</SPAN>[/TD]
[TD]167</SPAN>[/TD]
[TD]151</SPAN>[/TD]
[TD]90%</SPAN>[/TD]
[/TR]
[TR]
[TD]15-Aug</SPAN>[/TD]
[TD]167</SPAN>[/TD]
[TD]152</SPAN>[/TD]
[TD]91%</SPAN>[/TD]
[/TR]
[TR]
[TD]16-Aug</SPAN>[/TD]
[TD]167</SPAN>[/TD]
[TD]135</SPAN>[/TD]
[TD]81%</SPAN>[/TD]
[/TR]
[TR]
[TD]17-Aug</SPAN>[/TD]
[TD]167</SPAN>[/TD]
[TD]90</SPAN>[/TD]
[TD]54%</SPAN>[/TD]
[/TR]
[TR]
[TD]18-Aug</SPAN>[/TD]
[TD]167</SPAN>[/TD]
[TD]65</SPAN>[/TD]
[TD]39%</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[ExcelTactics]

This solution assumes that all data is within the same year... You can hide the columns in yellow - they just support the formulas in the green columns.The formulas in the initial row should drag down.

Excel 2010

	A	B	C	D	E	F	G	H	I	J
Date	Total Clients	# of Clients that Met Goal	PD % Achieved

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="bgcolor: #FFFF00"]Weekday[/TD]
[TD="bgcolor: #FFFF00"]Week #[/TD]
[TD="bgcolor: #92D050"]Week-to-Date PD % Achieved[/TD]
[TD="bgcolor: #FFFF00"]Month[/TD]
[TD="bgcolor: #FFFF00"]Day[/TD]
[TD="bgcolor: #92D050"]Month-to-Date PD % Achieved[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1-Aug[/TD]
[TD="align: right"]164[/TD]
[TD="align: right"]152[/TD]
[TD="align: right"]93.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]4[/TD]
[TD="bgcolor: #FFFF00, align: right"]31[/TD]
[TD="bgcolor: #92D050, align: right"]92.7%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]1[/TD]
[TD="bgcolor: #92D050, align: right"]92.7%[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]2-Aug[/TD]
[TD="align: right"]164[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]85.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]5[/TD]
[TD="bgcolor: #FFFF00, align: right"]31[/TD]
[TD="bgcolor: #92D050, align: right"]89.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]2[/TD]
[TD="bgcolor: #92D050, align: right"]89.0%[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]3-Aug[/TD]
[TD="align: right"]164[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]55.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]31[/TD]
[TD="bgcolor: #92D050, align: right"]77.6%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]3[/TD]
[TD="bgcolor: #92D050, align: right"]77.6%[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]4-Aug[/TD]
[TD="align: right"]164[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]25.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]7[/TD]
[TD="bgcolor: #FFFF00, align: right"]31[/TD]
[TD="bgcolor: #92D050, align: right"]64.5%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]4[/TD]
[TD="bgcolor: #92D050, align: right"]64.5%[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]5-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]75.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]1[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]75.5%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]5[/TD]
[TD="bgcolor: #92D050, align: right"]66.7%[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]6-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]75.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]2[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]75.5%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]6[/TD]
[TD="bgcolor: #92D050, align: right"]68.1%[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]7-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]81.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]3[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]77.3%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]7[/TD]
[TD="bgcolor: #92D050, align: right"]70.0%[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]8-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]87.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]4[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]79.6%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #92D050, align: right"]72.0%[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]9-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]87.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]5[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]81.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]9[/TD]
[TD="bgcolor: #92D050, align: right"]73.6%[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]10-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]51.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]76.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]10[/TD]
[TD="bgcolor: #92D050, align: right"]71.4%[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]11-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]26.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]7[/TD]
[TD="bgcolor: #FFFF00, align: right"]32[/TD]
[TD="bgcolor: #92D050, align: right"]68.9%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]11[/TD]
[TD="bgcolor: #92D050, align: right"]67.3%[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]12-Aug[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]130[/TD]
[TD="align: right"]80.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]1[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]79.8%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]12[/TD]
[TD="bgcolor: #92D050, align: right"]68.3%[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]13-Aug[/TD]
[TD="align: right"]168[/TD]
[TD="align: right"]143[/TD]
[TD="align: right"]85.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]2[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]82.5%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]13[/TD]
[TD="bgcolor: #92D050, align: right"]69.6%[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]14-Aug[/TD]
[TD="align: right"]167[/TD]
[TD="align: right"]151[/TD]
[TD="align: right"]90.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]3[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]85.1%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]14[/TD]
[TD="bgcolor: #92D050, align: right"]71.2%[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]15-Aug[/TD]
[TD="align: right"]167[/TD]
[TD="align: right"]152[/TD]
[TD="align: right"]91.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]4[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]86.6%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]15[/TD]
[TD="bgcolor: #92D050, align: right"]72.5%[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]16-Aug[/TD]
[TD="align: right"]167[/TD]
[TD="align: right"]135[/TD]
[TD="align: right"]81.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]5[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]85.5%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]16[/TD]
[TD="bgcolor: #92D050, align: right"]73.0%[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]17-Aug[/TD]
[TD="align: right"]167[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]54.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]6[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]80.2%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]17[/TD]
[TD="bgcolor: #92D050, align: right"]71.9%[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]18-Aug[/TD]
[TD="align: right"]167[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]39.0%[/TD]
[TD="bgcolor: #FFFF00, align: right"]7[/TD]
[TD="bgcolor: #FFFF00, align: right"]33[/TD]
[TD="bgcolor: #92D050, align: right"]74.3%[/TD]
[TD="bgcolor: #FFFF00, align: right"]8[/TD]
[TD="bgcolor: #FFFF00, align: right"]18[/TD]
[TD="bgcolor: #92D050, align: right"]70.0%[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]=WEEKDAY(A2,2)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F2[/TH]
[TD="align: left"]=WEEKNUM(A2,2)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]G2[/TH]
[TD="align: left"]=SUMIFS(C:C,F:F,WEEKNUM(A2,2),E:E,"<="&WEEKDAY(A2,2))/SUMIFS(B:B,F:F,WEEKNUM(A2,2),E:E,"<="&WEEKDAY(A2,2))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H2[/TH]
[TD="align: left"]=MONTH(A2)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]I2[/TH]
[TD="align: left"]=DAY(A2)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]J2[/TH]
[TD="align: left"]=SUMIFS(C:C,H:H,MONTH(A2),I:I,"<="&DAY(A2))/SUMIFS(B:B,H:H,MONTH(A2),I:I,"<="&DAY(A2))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[markmzz]

Maybe this:

Layout:

[TABLE="width: 198"]
<colgroup><col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="2"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="38" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1389;"> <tbody>[TR]
[TD="class: xl63, width: 40, bgcolor: transparent"]Date[/TD]
[TD="class: xl64, width: 40, bgcolor: transparent"]Total Clients[/TD]
[TD="class: xl64, width: 58, bgcolor: transparent"]# of Clients that Met Goal[/TD]
[TD="class: xl64, width: 50, bgcolor: transparent"]PD % Achieved[/TD]
[TD="class: xl63, width: 36, bgcolor: transparent"]Week[/TD]
[TD="class: xl63, width: 38, bgcolor: transparent"]Month[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]01/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]152[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]93%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]92,7%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]92,7%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]02/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]140[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]85%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]89,0%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]89,0%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]03/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]90[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]55%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]77,6%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]77,6%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]04/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]41[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]25%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]64,5%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]64,5%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]05/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]123[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]75%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]75,5%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]66,7%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]06/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]123[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]75%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]75,5%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]68,1%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]07/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]132[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]81%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]77,3%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]70,0%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]08/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]141[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]87%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]79,6%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]72,0%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]09/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]141[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]87%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]81,0%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]73,6%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]10/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]83[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]51%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]76,0%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]71,4%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]11/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]43[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]26%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]68,9%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]67,3%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]12/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]130[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]80%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]79,8%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]68,3%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]13/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]168[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]143[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]85%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]82,5%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]69,6%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]14/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]151[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]90%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]85,1%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]71,2%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]15/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]152[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]91%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]86,6%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]72,5%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]16/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]135[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]81%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]85,5%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]73,0%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]17/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]90[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]54%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]80,2%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]71,9%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]18/ago[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]39%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]74,3%[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]70,0%[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]*******[/TD]
[TD="class: xl63, bgcolor: transparent"]*******[/TD]
[TD="class: xl63, bgcolor: transparent"]**********[/TD]
[TD="class: xl63, bgcolor: transparent"]*********[/TD]
[TD="class: xl63, bgcolor: transparent"]******[/TD]
[TD="class: xl63, bgcolor: transparent"]*******[/TD]
[/TR]
</tbody>[/TABLE]


Formulas:

E2-> =SUMIFS(C:C,A:A,"<="&A2,A:A,">="&A2-MOD(A2-2,7))/SUMIFS(B:B,A:A,"<="&A2,A:A,">="&A2-MOD(A2-2,7))

With date in Excel configured for 1900.

F2-> =SUMIFS(C:C,A:A,"<="&A2,A:A,">="&EOMONTH(A2,-1)+1)/SUMIFS(B:B,A:A,"<="&A2,A:A,">="&EOMONTH(A2,-1)+1)

Markmzz

 

[bolwahnn]

Thanks! this works pretty good except when I get to a new month - from the example given, say my PD % acheived on September 1st is 85%, this should be the same number that is on the MTD % achieved. Right now it reports a different number. Any ideas as to why this is happening?


Thanks again.

 

[markmzz]

Thanks! this works pretty good except when I get to a new month - from the example given, say my PD % acheived on September 1st is 85%, this should be the same number that is on the MTD % achieved. Right now it reports a different number. Any ideas as to why this is happening?


Thanks again.

Here is ok. Look at this:

[TABLE="width: 198"]
<colgroup><col width="40" style="width: 30pt; mso-width-source: userset; mso-width-alt: 1462;" span="2"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="38" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1389;"> <tbody>[TR]
[TD="class: xl65, width: 40, bgcolor: transparent"]Date[/TD]
[TD="class: xl66, width: 40, bgcolor: transparent"]Total Clients[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]# of Clients that Met Goal[/TD]
[TD="class: xl66, width: 50, bgcolor: transparent"]PD % Achieved[/TD]
[TD="class: xl65, width: 36, bgcolor: transparent"]Week[/TD]
[TD="class: xl65, width: 38, bgcolor: transparent"]Month[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: #8DB4E2, align: right"]01/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]152[/TD]
[TD="class: xl70, bgcolor: #8DB4E2, align: right"]92,7%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]92,7%[/TD]
[TD="class: xl71, bgcolor: #8DB4E2, align: right"]92,7%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]02/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]140[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]85,4%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]89,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]89,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]03/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]90[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]54,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]77,6%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]77,6%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]04/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]41[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]25,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]64,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]64,5%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]05/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]75,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]75,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]66,7%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]06/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]75,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]75,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,1%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]07/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]132[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]81,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]77,3%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]70,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]08/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]141[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]86,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]79,6%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]72,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]09/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]141[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]86,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]81,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]73,6%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]10/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]83[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]50,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]76,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]71,4%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]11/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]43[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]26,4%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]67,3%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]12/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]130[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]79,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]79,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,3%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]13/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]168[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]143[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]85,1%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]82,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]69,6%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]14/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]151[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]90,4%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]85,1%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]71,2%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]15/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]152[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]91,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]86,6%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]72,5%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]16/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]135[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]80,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]85,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]73,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]17/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]90[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]53,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]80,2%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]71,9%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]18/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]65[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]38,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]74,3%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]70,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]19/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]164[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]41[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]25,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]25,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]67,7%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]20/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]75,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]50,2%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,1%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]21/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]123[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]75,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]58,6%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,4%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]22/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]132[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]81,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]64,2%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]69,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]23/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]141[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]86,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,6%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]69,7%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]24/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]141[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]86,5%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]71,6%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]70,4%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]25/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]83[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]50,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,7%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]69,6%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]26/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]43[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]26,4%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]26,4%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]27/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]163[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]130[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]79,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]53,1%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]68,4%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]28/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]168[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]143[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]85,1%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]64,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]69,0%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]29/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]151[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]90,4%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]70,7%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]69,8%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]30/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]152[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]91,0%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]74,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]70,5%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]31/ago[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]135[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]80,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]75,8%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]70,8%[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: #8DB4E2, align: right"]01/set[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]90[/TD]
[TD="class: xl70, bgcolor: #8DB4E2, align: right"]53,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]72,6%[/TD]
[TD="class: xl71, bgcolor: #8DB4E2, align: right"]53,9%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]02/set[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]167[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]65[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]38,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]38,9%[/TD]
[TD="class: xl68, bgcolor: yellow, align: right"]46,4%[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]*******[/TD]
[TD="class: xl65, bgcolor: transparent"]*******[/TD]
[TD="class: xl65, bgcolor: transparent"]**********[/TD]
[TD="class: xl65, bgcolor: transparent"]*********[/TD]
[TD="class: xl65, bgcolor: transparent"]******[/TD]
[TD="class: xl65, bgcolor: transparent"]*******[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz

 

[bolwahnn]

My apologies - User error

 

[markmzz]

My apologies - User error

No problem and thanks for the feedback.

Markmzz