| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare dates with lag
I need a formula to check for status=Closed and delivery within 2 days of
requested date. A B C Status Requested Date Delivered Date ===== ============ =========== Closed 10/16/07 13:31 12/5/07 15:17 Submitted 10/16/07 13:31 12/5/07 15:17 Submitted 10/16/07 13:31 12/5/07 15:17 Closed 10/16/07 16:11 12/18/07 16:29 Submitted 10/19/07 9:58 10/19/07 12:02 Submitted 10/19/07 9:58 10/19/07 12:08 Closed 10/19/07 9:58 10/19/07 12:08 Submitted 10/19/07 9:58 10/19/07 12:08 Closed 10/19/07 10:44 10/31/07 17:06 Submitted 10/19/07 10:44 10/31/07 17:06 Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare dates using a variable | Excel Worksheet Functions | |||
| compare dates | Excel Worksheet Functions | |||
| Compare two dates and if they are equal | Excel Discussion (Misc queries) | |||
| how do I compare two dates? | Excel Worksheet Functions | |||
| Compare range of dates and sum... | Excel Discussion (Misc queries) | |||
Threaded Mode
