Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates: How many entries per week?
I have a spreadsheet with entries by date. I would like to know how many
entries per week there are. I have created a list of beginning dates for weeks, as in a1=8/17/05, a2=8/24/05 and was attempting to count for datea1 and <a2. Is there an easy way to do this? Alternative is there a way to count how many entries per month? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates: How many entries per week?
If your dates are in cells A5:A50, you can try this matrix formula:
=SUM(IF(AND(A5:A50A1;A5:A50<A2);1;0)) Remember that matrix formulas MUST be finished with a CTRL+SHIFT+ENTER -- Rogerio Takejame Americana - Sao Paulo - Brazil "Jill" wrote: I have a spreadsheet with entries by date. I would like to know how many entries per week there are. I have created a list of beginning dates for weeks, as in a1=8/17/05, a2=8/24/05 and was attempting to count for datea1 and <a2. Is there an easy way to do this? Alternative is there a way to count how many entries per month? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates: How many entries per week?
This is not working for me. I get an error message about Logical1 that points
to a1. Should A1 not be a date? I have it as the 8/7/05 of the first date to check against. Thanks "Rogerio Takejame" wrote: If your dates are in cells A5:A50, you can try this matrix formula: =SUM(IF(AND(A5:A50A1;A5:A50<A2);1;0)) Remember that matrix formulas MUST be finished with a CTRL+SHIFT+ENTER -- Rogerio Takejame Americana - Sao Paulo - Brazil "Jill" wrote: I have a spreadsheet with entries by date. I would like to know how many entries per week there are. I have created a list of beginning dates for weeks, as in a1=8/17/05, a2=8/24/05 and was attempting to count for datea1 and <a2. Is there an easy way to do this? Alternative is there a way to count how many entries per month? thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates: How many entries per week?
OK, try this one that is simpler:
=SUM((A5:A50A1)*(A5:A50<A2)) Don't forget the CTRL+SHIFT+ENTER -- Rogerio Takejame Americana - Sao Paulo - Brazil "Jill" wrote: This is not working for me. I get an error message about Logical1 that points to a1. Should A1 not be a date? I have it as the 8/7/05 of the first date to check against. Thanks "Rogerio Takejame" wrote: If your dates are in cells A5:A50, you can try this matrix formula: =SUM(IF(AND(A5:A50A1;A5:A50<A2);1;0)) Remember that matrix formulas MUST be finished with a CTRL+SHIFT+ENTER -- Rogerio Takejame Americana - Sao Paulo - Brazil "Jill" wrote: I have a spreadsheet with entries by date. I would like to know how many entries per week there are. I have created a list of beginning dates for weeks, as in a1=8/17/05, a2=8/24/05 and was attempting to count for datea1 and <a2. Is there an easy way to do this? Alternative is there a way to count how many entries per month? thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates: How many entries per week?
Rogerio, no error message now, but an answer of 0 which is clearly not true.
Thanks, Jill "Rogerio Takejame" wrote: OK, try this one that is simpler: =SUM((A5:A50A1)*(A5:A50<A2)) Don't forget the CTRL+SHIFT+ENTER -- Rogerio Takejame Americana - Sao Paulo - Brazil "Jill" wrote: This is not working for me. I get an error message about Logical1 that points to a1. Should A1 not be a date? I have it as the 8/7/05 of the first date to check against. Thanks "Rogerio Takejame" wrote: If your dates are in cells A5:A50, you can try this matrix formula: =SUM(IF(AND(A5:A50A1;A5:A50<A2);1;0)) Remember that matrix formulas MUST be finished with a CTRL+SHIFT+ENTER -- Rogerio Takejame Americana - Sao Paulo - Brazil "Jill" wrote: I have a spreadsheet with entries by date. I would like to know how many entries per week there are. I have created a list of beginning dates for weeks, as in a1=8/17/05, a2=8/24/05 and was attempting to count for datea1 and <a2. Is there an easy way to do this? Alternative is there a way to count how many entries per month? thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates: How many entries per week?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
How do I combine a list of dates & a value into 1 week intervals | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |