Counting dates, within a list of dates
 

I am a fairly new excel user. I am a contractor and wish to find out how many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

=SUMIF(A:A,"="&first_date)-SUMIF(A:A,""&second_date)

where column A holds your dates and first_date and second_date are cell
references to those respective dates.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time
the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

Now I need to add to what You've helped me with.
Determine how many dates are in a specific date range, but only if another
column shows a 1 instead of a 2 ??

"Don Guillett" wrote:

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time
the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

A B C D E F
1 3/21 1
2 3/28 1
3 4/15 2
4 4/18 1
5 1/28 2
6 2/15 1
7 2/28 1

Dates to count 2/28 - 4/18 but only if D is 1. the answer would be 4?

"jrheinschm" wrote:

Now I need to add to what You've helped me with.
Determine how many dates are in a specific date range, but only if another
column shows a 1 instead of a 2 ??

"Don Guillett" wrote:

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time
the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

Counting dates, within a list of dates
 

=sumproduct(--(a4:a22=a1),--(a4:a22<a2),--(D4:D22=1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jrheinschm" wrote in message
...
A B C D E F
1 3/21 1
2 3/28 1
3 4/15 2
4 4/18 1
5 1/28 2
6 2/15 1
7 2/28 1

Dates to count 2/28 - 4/18 but only if D is 1. the answer would be 4?

"jrheinschm" wrote:

Now I need to add to what You've helped me with.
Determine how many dates are in a specific date range, but only if
another
column shows a 1 instead of a 2 ??

"Don Guillett" wrote:

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man!
It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in
message
...
I am a fairly new excel user. I am a contractor and wish to find
out how
many
estimates we send out weekly from a dated list. We typically have
many
estimates daily and wish to determine over a specific amount of
time
the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help