<div>
Clarification needed:<br />
<br />
Do you want to show dates from 1-5 as a grouping? Or do you want to show day by day?. The first one you can see above, while the second one I need some extra info about.<br />
<br />
regards<br />
<br />
Jørgen
</div>


Clarification needed:

Do you want to show dates from 1-5 as a grouping? Or do you want to show day by day?. The first one you can see above, while the second one I need some extra info about.

regards

Jørgen

<div>
Hi jorgen....<br />
<br />
nailed it...thanks for the feedback.
</div>


Hi jorgen....

nailed it...thanks for the feedback.

<div>
You are welcome - thanks for the points
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts excel 2007<br />
<br />
how would you show dates in a pivot table as follows:<br />
<br />
col A<br />
01/02/2014<br />
02/02/2014<br />
03/02/2014<br />
04/02/2014<br />
05/02/2014<br />
<br />
as in a pivot table 01/02/2014 - 05/02/2014
</div>
</div>


Hi Experts excel 2007

how would you show dates in a pivot table as follows:

col A
01/02/2014
02/02/2014
03/02/2014
04/02/2014
05/02/2014

as in a pivot table 01/02/2014 - 05/02/2014

pivot table dates 2007 tricky

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.