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

--
Message posted from http://www.ExcelForum.com