to Calculate Summary of total Qty based on LeadTime

Hi

i need help to calculate qty arrived at receiver stand point based on lead time for each areas

i thought i found the formulas but it is not

so the problem is how to translated the date by using the Lead time for each areas on D9:S11 and do summary based on logic : Delivery date plus LEad time

the Helper table actually done by me manually to help me get the result ... but i have 4k rows to calculate and cannot be done manually
example : in D9 , delivery date is 31 oct... so it will be arrived in 4 november which is AA9 cell (Date of Delivery date plus 4 days lead time) ..

i attached file for better understanding

i put helper table to help me, but then i realized, i put number there manually (W9:AL11)
so i need formula to translate whether with helper table (if so then i need formulas in helper table W9:AL11)
or if someone can perfectly summary the total qty without helper table (if so then the formulas will be in AM9:AO11)

thank in advance

I don't see where you have manually mocked up any expected results - please do this and post the updated workbook. Add notes to the workbook explaining your calculations.

Hi Ali,
i revised as i changed my attached file

at the moment i will clsed this thread first ..

@Did13n

Administrative Note:

Welcome to the forum.

Unfortunately, it has come to our attention you have violated Rule #8 of our Forum RULES:

Don't private message, visitor message or email Excel (or Access, Word, etc.) questions to moderators or other members.

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to a permanent ban, so do take this caution to heart.

Post your question in a public thread and our many contributors will come to your assistance, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.

In the meantime you can try this formula in AM9 and copy it down and across to AO11.

Formula:

Please Login or Register  to view this content.

aplogize. too much mistaken as i did not really read the rules. will try to read all and follow

ps : thanks for your help ... but it is not what i need .. the formula you given already same result with mine ... the area to compute is from D9 to S11

however thanks for your intention to help... appreciate.. n once again. sorry

Create table of Start/end dates for each week (AS5:AU7) in attached

in AM9

Formula:

Please Login or Register  to view this content.

Copy across and down

Sample rsults in AQ9:AS11

you are my savior John ... Brilliant ... !!!