| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - count the number of records between two specific dates.
I need to count the number of records between two specific dates. Using
excel 2007. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - count the number of records between two specific dates.
=SUMPRODUCT(--(A:A<=--"2008-01-01"),--(A:A=--"2008-03-31"))
or if the dates are in other cells =SUMPRODUCT(--(A:A<=M1),--(A:A=M2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DK" wrote in message ... I need to count the number of records between two specific dates. Using excel 2007. Can anyone help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - count the number of records between two specific dates
Hi Bob
I'm obviously doing something wrong as it still doesn't work. All data on one workhseet. Dates to be searched are in column K. Dates from and to are in two seperate cells in different columns. using the following formula =SUMPRODUCT(--(K2:K500<=DD401), --(K2:K500=DE401)) - typed exactly as shown produces the result 0 but there is data that should have been counted. Any further advice? "Bob Phillips" wrote: =SUMPRODUCT(--(A:A<=--"2008-01-01"),--(A:A=--"2008-03-31")) or if the dates are in other cells =SUMPRODUCT(--(A:A<=M1),--(A:A=M2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DK" wrote in message ... I need to count the number of records between two specific dates. Using excel 2007. Can anyone help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - count the number of records between two specific dates
I got my <= and = the wrong way around, did you also?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DK" wrote in message ... Hi Bob I'm obviously doing something wrong as it still doesn't work. All data on one workhseet. Dates to be searched are in column K. Dates from and to are in two seperate cells in different columns. using the following formula =SUMPRODUCT(--(K2:K500<=DD401), --(K2:K500=DE401)) - typed exactly as shown produces the result 0 but there is data that should have been counted. Any further advice? "Bob Phillips" wrote: =SUMPRODUCT(--(A:A<=--"2008-01-01"),--(A:A=--"2008-03-31")) or if the dates are in other cells =SUMPRODUCT(--(A:A<=M1),--(A:A=M2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DK" wrote in message ... I need to count the number of records between two specific dates. Using excel 2007. Can anyone help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - count the number of records between two specific dates
Thanks Bob - works perfectly. Much appreciated DK
"Bob Phillips" wrote: I got my <= and = the wrong way around, did you also? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DK" wrote in message ... Hi Bob I'm obviously doing something wrong as it still doesn't work. All data on one workhseet. Dates to be searched are in column K. Dates from and to are in two seperate cells in different columns. using the following formula =SUMPRODUCT(--(K2:K500<=DD401), --(K2:K500=DE401)) - typed exactly as shown produces the result 0 but there is data that should have been counted. Any further advice? "Bob Phillips" wrote: =SUMPRODUCT(--(A:A<=--"2008-01-01"),--(A:A=--"2008-03-31")) or if the dates are in other cells =SUMPRODUCT(--(A:A<=M1),--(A:A=M2)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DK" wrote in message ... I need to count the number of records between two specific dates. Using excel 2007. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count certain records between dates | Excel Discussion (Misc queries) | |||
| Number of records between dates | Excel Discussion (Misc queries) | |||
| Determining the number of specific days between two dates in Excel | Excel Worksheet Functions | |||
| Number of records by Month that meet a specific requirement | Excel Worksheet Functions | |||
| count the no.of records between two dates | Excel Worksheet Functions | |||
Hybrid Mode
