Create Pivot Table for Weekly Totals

[jubiesxl]

My accounting system exports to excel the vendor amount due on due date basis, but I would like the totals due on weekly basis.

For example:
Vendor Name Amount Due Date
Abc 500 May 3
Bcd 256 May 5
Cde 300 May 9
Def 155 May 13
Efg 267 May 17
Fgh 364 May 22
Ghi 231 May 23
Hij 898 May 25
Ijk 23 May 27
JJJ 999 May 31

I would like to set up a look up or a table to sum total the due amount as of each friday (end of week) say May 4th, then May 11th and then May 18th and so on.

I hope I am making sense and wonder if it is possible at all to create a summary weekly totals.

Thank you very much and any suggestion is welcome

 

[AhoyNC]

See attached.
Shows both pivot table & formula for weekly summary.

http://www.youtube.com/watch?v=Lkd_k4WDbVw&feature=plcp

 

[jubiesxl]

AhoyNC....awesome help...I was at my wits end to figure out the grouping of days in pivot table and the lookups...and the solution 'now' seems to be so simple.

Thanks again