aging days between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
For business days between dates take a look at NETWORKDAYS in help,
for pivot tables do a Google search for Contextures and Dalgleish
 
Back
Top