Counting Dates

[Dilly]

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?

 

[David McRitchie]

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.

 

[Dilly]

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"))

 

[Dilly]

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"))