If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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")) |
#2
|
|||
|
|||
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")) |
Thread Tools | |
Display Modes | |
|
|