Dynamic Columns/Column Headers

[mbrewer1974]

Note: Starting in this forum but this could be a better fit elsewhere depending on the solution approach.

I have the following two variables:

Est. Project Duration (weeks): X
Est. Project Start Date (monday): Y

I would like to be able to take the above information from tab A (X, Y) and create a staffing model on tab B. My thought is that if I have a start date (monday) of '8/15/16' and a project duration of '8', that I could dynamically create column headers for 8/15, 8/22, 8/29, 9/5, 9/12, 9/19, 9/26 & 10/3.

Any thoughts?

[oeldere]

blad3!a1 8
blad3!a2 15-8-2016

blad 2 a1 =Blad3!A2
blad 2 b1 =if(column()<=Blad3!$A$1,A$1+7,"") and drag to the right.

and format as date.

[mbrewer1974]

Ah, very good. Thanks oeldere. Once I got past the references to 'blad' your solution worked as expected.

Thanks for your help.

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.