Due Date dependent on predecessor AND allocation %

amun66991

Hi, 

I'm trying to get end dates to change based on estimated hours AND allocation %.

 

Is that possible? How do you do this? 

 

Thanks!

L_123

the formula

=date1 + 1

will add a single day to the date in the date column first row.

knowing that dates can be manipulated this way, we can use a simple statement to adjust the date

=date1 + ([Estimated Hours]1*Value + [Alocation %]1*Value)

If you want to make it more complex you can use an if statement to make a faux variable to adjust the date based on criteria.

=date1 + if([Allocation %]1 > 50%, [Stock Project Duration]1 * 1.25)

 

Or something like that.