Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting dates Annie99 Excel Discussion (Misc queries) 7 October 8th 07 10:36 PM
counting occasions dates occur between 2 dates hoyt New Users to Excel 5 June 16th 06 08:11 AM
Counting dates, within a list of dates jrheinschm Excel Worksheet Functions 7 April 19th 06 06:13 PM
COUNTING DATES Cody Excel Discussion (Misc queries) 3 November 27th 05 03:51 AM
Counting Dates Jerry Excel Worksheet Functions 3 March 11th 05 05:19 AM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"