Get Max Date From PivotTable

  • Thread starter Thread starter GarethG
  • Start date Start date
G

GarethG

I have a PivotTable *I start every post with that these days*
I have my PivotTables do pretty much everything except make my coffe
(If anyone knows the VB for that let me know :])

Anyway...The PivotTable has records relating to the current month
sales and the datasource is refreshed every day.
What I want is some VB (I figured it could only be done with VB), tha
will look at the range of dates in the Date Field and return the lates
(highest date).

I need this to drop into my worksheet to show when or how far the dat
goes upto.

The second part is to calculate the number of working days that hav
passed.

Anyone?
Gareth
 
Can't you just use the Worksheet MAX function , either in the worksheet or
in code.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Codeing behind a PivotTable 14
Yet another progress bar Question 1
How to maintain dynamic data range for Excel PivotTable 4
Pivottable Field items code -problems 2
Pivot Tables.... 2
Difference column in PivotTable 1
pivot table using vba problem 1
PivotTable from a ADODB.Recordset ? 7

Back
Top