Thread: Date Question
View Single Post
  #1   Report Post  
Old October 29th 04, 05:42 AM
G
 
Posts: n/a
Default Date Question

I have an Excel SS that has a summary page that has several count if / sum if
values. Many of which refer to date ranges. today etc.

Is it possible for me to capture all data in a range of the last calander
month ie. if i all dates in October.

Currently i have the formulas written to count details within the last 31
days however i would like to make this a little more correct.

example :
=SUMPRODUCT((whoC="gn") * (typec="email " ) * (whenb<B1) * ( whenb B2) )

B1 = Now()
B2 = B1 - 31

Any help very much appreciated