Thread: Counting Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dilly Dilly is offline
external usenet poster
 
Posts: 14
Default Counting Dates

Column A contains a list of dates that a call was made to a Helpdesk, column
B contains a list of dates giving the Programmed Response dates for each call
to the helpdesk. How do i establish those calls to the Heldesk made in April
2009 AND that also have a programmed response date of April 2009 ??

Further we have a yes/no indicator in Column C highlighting if a job was
completed prior to its programmed response. Is their a formula that will
count the number of calls made in April 2009, has a programmed response of
April 2009 and has a yes indicator for completion prior to its programmed
response?