Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Days between 2 dates Nicky Excel Worksheet Functions 8 February 22nd 07 02:30 PM
Days between 2 dates Linda RQ New Users to Excel 6 November 28th 06 11:41 PM
days and dates msiz Excel Discussion (Misc queries) 6 October 24th 06 12:41 PM
days and dates msiz Excel Discussion (Misc queries) 1 October 23rd 06 04:24 PM
Calculating number of days between two dates that fall between two other dates [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM


All times are GMT +1. The time now is 01:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"