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
|