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 ?? To make
matters a little more difficult the dates are not a continuous string of
dates and are seperated (randomly) by text. I have been provided with the
folrmula below but it doesn't work :0(

=SUMPRODUCT(--(TEXT(A2:A14,"yyyy\-mm;;;")="2009-02"))*(--(TEXT(B2:B14,"yyyy\-mm;;;")="2009-02"))

Counting Dates
 

Try
=SUMPRODUCT(--(TEXT(A2:A14,"yyyy-mm")="2009-04"),(--(TEXT(B2:B14,"yyyy-mm")="2009-04")))

The formula being used by you has the wrong date format and checks for dates
in Feb 2009 (="2009-02")

"Dilly" wrote:

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 ?? To make
matters a little more difficult the dates are not a continuous string of
dates and are seperated (randomly) by text. I have been provided with the
folrmula below but it doesn't work :0(

=SUMPRODUCT(--(TEXT(A2:A14,"yyyy\-mm;;;")="2009-02"))*(--(TEXT(B2:B14,"yyyy\-mm;;;")="2009-02"))