aging days between dates
 

I have a huge order log with no less than 10 different dates as it goes from
creation to billing. I need to find the business days difference between
each date, then count orders and put to pivot table based on hit goal, didn't
hit goal & no final date entered. Sorry pretty much a novice on pivots.

aging days between dates
 

For business days between dates take a look at NETWORKDAYS in help,
for pivot tables do a Google search for Contextures and Dalgleish



--

Regards,

Peo Sjoblom

"Karel" wrote in message
...
I have a huge order log with no less than 10 different dates as it goes
from
creation to billing. I need to find the business days difference between
each date, then count orders and put to pivot table based on hit goal,
didn't
hit goal & no final date entered. Sorry pretty much a novice on pivots.