We invoice customers in weekly batches (Table A). Recurring invoices
are due to be raised at various intervals eg: monthly, 28 days, 18 days etc
(Table B). What formual can I put in Table A that shows the right
invoice date from Table B in the right column on Table A

TABLE A
Invoicing batches Batch 1 Batch 2 Batch 3
Invoice date - From 27/07/05 03/08/05 10/08/05
Invoice date - To 02/08/05 09/08/05 16/08/05
Customer 1 ??? ??? ???
Customer 2 ??? ??? ???
Customer 3 ??? ??? ???

TABLE B
Invoice dates
Customer 1 Mth 01/08/05 01/09/05 01/10/05
Customer 2 28 02/08/05 30/08/05 27/09/05
Customer 3 18 25/07/05 12/08/05 30/08/05

With thanks
--
Peter
London, UK