Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that compares dates
Is there a way to do this?? I want to create a chart based on the following.
Column 1 has the date a document request was received from my customer. Column 2 has the date the document was returned to my customer. Column 1 has dates starting 01/01/05 and continues thru 03/31/06 (15 months) Column 2 has the same dates - 01/01/05 thru 03/31/06 I want identify those requests that were returned to the customer within 3 business days of receiving the request. There are approximately 2,500 lines of text, so manually comparing the dates is out of the question. Any suggestions would be greatly appreciated. Thanks, getravel (Mike) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that compares dates
Hi Mike,
Take a look at Data Autofilter ... HTH Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that compares dates
Mike,
Sorry I answered too quickly ... In the first available column, have this calculation : =NETWORKDAYS(A2,B2) Then copy it all the way down to your 2500 rows ... And only then use Data Autofilter ... and Custom to refine your filtering ... HTH Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using IF function with Dates as parameters | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
How do I use the excel timeline function with dates in graphs | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |