date comparison in pivot table error

[Planner1]

I have to generate a report using a pivot table, that tells me what work was done on time and what was late. Entering a formula outside the pivot table sees the scheduled start date drop downs as "blank" and says they are late when they are not. I cannot seem to use the value fields when i try to create a calculation field within the table. any suggestions? I am not familiar with VBA, but I guess I am going to have to learn it. I use 2010 at work, 2007 at home.

Excel Workbook
	F	G	H	I	J	K
10	Count of WO No.				=IF(G12>=H12, I12," ")	=IF(G12<="" td="">
11	WO Type	Scheduled Start Date	Completion Date	Total	ONTIME	LATE
12	ENVIRO/PM	9/12/2011	9/12/2011	1	1
13		9/16/2011	9/16/2011	1	1
14		9/22/2011	9/15/2011	1	1
15	PM	9/9/2011	9/14/2011	1		1
16		9/10/2011	9/12/2011	1		1
17			9/16/2011	1		1
18		9/12/2011	9/12/2011	16	16
19			9/13/2011	1		1
20		9/13/2011	9/13/2011	28	28
21		9/14/2011	9/12/2011	1	1
22			9/13/2011	1	1	1
23			9/14/2011	2	2	2
24			9/15/2011	2		2
25		9/15/2011	9/12/2011	1	1
26		9/16/2011	9/12/2011	2	2
27			9/13/2011	1	1	1
28			9/14/2011	2	2	2
29			9/15/2011	4	4	4
sep 11-17

Excel 2007

 

[Derek Brown]

Hello and welcome to The Board.

I would have another column, outside the pivot table, to fill in the blanks and then I would have the formula check against that.

For example, in L12 the formula would be:
=IF(G12="",J11,G12)

The column could later be hidden if required.

 

[Planner1]

That doesn't work, the result I get for the "blank" (there are hidden dates there) is<TABLE style="WIDTH: 54pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=72><COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" id=td_post_2879951 class=xl69 height=17 width=72 align=right>1/0/00</TD></TR></TBODY></TABLE>

 

[Derek Brown]

Try:
=IF(OR(G12="",G12=0),J11,G12)