So I have a file that has a cell with a predicted turn time date for getting a task done. which is based on a date in another cell (original date) + 10 days. I have 2 or more other cells that have dates entered for other parts that need to be added in if they take longer...if any of these dates are farther along than the original date listed (the original date cell) then the number of days they are farther along should also be added into the predicted turn time date ie original date +10 days + 1 day (this day was one day further than the original) +2 (another that was further along) etc. I am trying to get the calc to do this. see below
a1 = 1/1/10 (original date)
a2 =1/2/10(one day over original date)
a3= 1/3/10(2 days over original date)
a4 = predicted turn time (original date +10 days +1 day over original +2 days over original) = 1/14/10
Hope i am not confusing the issue. some some of the extra fields added may not always be used in the predicted turn time unless they are after the original date and they are applicable, in some cases we would not enter a date in them so it would not add to the predicted date.
thank you for any help!!!!
Bookmarks