Gantt Chart help please! Formula to calculate date range based on budgeting criteria

[cmeurrens]

I am trying to find a formula for a Gantt chart that will calculate and fill in the graph dates based on a budget dollar amount entered. If the budget dollar amount is $100, and each week is "worth" $2, I need the formula to calculate how many weeks the $100 would cover and fill in the bar graph dates accordingly. In this example it would fill in 50 weeks worth on the Gantt chart automatically. Thoughts on a formula for this? Thanks!

 

[cmeurrens]

I actually figured this out - much easier than I thought it was going to be. Thanks.