I am building a database that allows users to enter their weekly activities.
Each user will have their own page and will be able to enter the date they
worked into the form as well as the activity they participated in. I have
embedded formulas that caluclate how many "points" each of these activity
sessions is worth.
My problem is that I am trying to build a formula that searches through the
entered dates, extracts the associated points out of the database for each
quarter, and totals the points. For instance, I would like the function to
look through 100 entries, determine which entries occurred between July 1st
and September 30th and total all the points that occurred in that time
period. It doesn't seem that difficult, but I am really struggling to make
Excel sift through dates.
Help???

Thanks!