View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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