Weekly Totals Based on Dates

J

JerryS

Hi Everybody,

I keep a table that tracks an item with columns of dates when milestones are
met. I want to be able to generate a report each week that totals events that
happened during the previous week. The table I keep looks something like this:

Property Units Type Proposed Contracted Released
ABC 200 New 06/22/08 06/24/08 06/28/08
DEF 150 Used 06/01/08 06/27/08 07/28/08
GHI 300 New 06/25/08 07/25/08 08/01/08

I want a report that shows for the week ending 06/28/08, looks like this:

New Used Proposed Contracted Released
500 150 650 650 200

Suggestions and formulas are greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top