View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Fool on the Hill The Fool on the Hill is offline
external usenet poster
 
Posts: 58
Default Calculating whether solution is in time or not

Dear Excel(lent) users,

I have a list in which al sent requests are logged. Every request has a
priority, each priority defines in what time a request needs to be executed.

To clarify:
In Column A I use the date of the sent request
In Column B I use the date of the request being executed
In Column C I use the priority of the request

Column A Column B Column C
-------------- ------------- ----------
01-01-2008 02-01-2008 1
01-02-2008 02-02-2008 2
01-03-2008 02-03-2008 3
01-04-2008 08-04-2008 1
01-04-2008 08-05-2008 4
01-04-2008 08-06-2008 5


If you take the following maximum processing time into consideration:

Priority max days to process
-------- -----------------------
1 1
2 2
3 5
4 10
5 15

I am looking for a formula which would give me the following information:

Priority Deadline met Deadline not met
-------- --------------- --------------------
1 1 1
2 1 0
3 1 0
4 0 1
5 0 1


Can you please help me ??