I'm not entirely sure I understand; you didn't say what does pull through,
and whether the problem begins with the first equation (=D1) pulling in the
header or only on subsequent rows pulling in the dates themselves. I'll take
a guess that the problem is only on the dates themselves, and that what
you're getting is numbers in the 38000 range. If so, it's just a format
issue; Excel stores dates as numbers, where 1 is in Jaunary 1900. If that's
the problem, just select the column and Edit Format, click the Numbers tab
and select a format in the Date category.

"Dennis" wrote:

using 2003

A Row field in PT is "Date"

It does not show in the table but I can choose any or all dates from a
drop-down box.

I can create a presentation to the right of the generated PT, by using "=A1"
referencing.

How can I display "Date" in the columns to the right?

The "Date" column is "D" one cell above the drop-down selector, but if I
refer like "=D1" the correct value does not pull through.

How can I get the "Date" to display to the right of the PT?

TIA

Dennis