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? |
Counting Dates
"Dilly" wrote in message ...
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? Just extend the reply you already got. Boolean multiplication each part resolves to a True (1) or False (0) and the sums are totaled. |
Counting Dates
It doesn't work, hence why i am asking for assistance?
I am currently using the formula below to establish the number of dates that have a date of February 2009 in column A AND column B. I am told i need this folrmula as the dates are seperated by different headings of text. However, it doesn't work =SUMPRODUCT(--(TEXT(A2:A14,"yyyy\-mm;;;")="2009-02"))*(--(TEXT(B2:B14,"yyyy\-mm;;;")="2009-02")) "David McRitchie" wrote: "Dilly" wrote in message ... 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? Just extend the reply you already got. Boolean multiplication each part resolves to a True (1) or False (0) and the sums are totaled. |
All times are GMT +1. The time now is 11:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com