Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting dates | Excel Discussion (Misc queries) | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions | |||
COUNTING DATES | Excel Discussion (Misc queries) | |||
Counting Dates | Excel Worksheet Functions |