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 ?? 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Dates
There were too many parenthesis in that formula. Corrected formula, for April:
=SUMPRODUCT((TEXT(A2:A14,"yyyy\-mm;;;")="2009-04")*(TEXT(B2:B14,"yyyy\-mm;;;")="2009-04")) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Dates | Excel Discussion (Misc queries) | |||
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 Worksheet Functions |