Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Days between 2 dates | Excel Worksheet Functions | |||
Days between 2 dates | New Users to Excel | |||
days and dates | Excel Discussion (Misc queries) | |||
days and dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |