Dynamic Cell Referencing

[bilaljamil]

I'm looking to make an order sheet. If preparation time is 14 days it means that it will take 2 weeks to complete it. I have distributed my data in columns starting from week 1 till week 10. If I enter an order in week 1 I want it to reflect it in week 3 as it takes 2 weeks to complete it and if I change the preparation time to 21 days meaning 3 weeks, and again if I place an order in week 1, I want to reflect it in week 4. I'm trying to build a logic using the "ADDRESS" and "INDIRECT" functions but ain't able to do it yet. Can anyone help me with this?

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.