View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adimar adimar is offline
external usenet poster
 
Posts: 49
Default 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.