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
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