ExcelBanter - Excel

hi
for the way you described, not really. formulas return values, they cannot
perform actions such as put data in other cells. so you would need a formula
in each date cell to calculate that date.
but it would be simple. all you have to do is as 1 to the previous date for
each day in the future you wish to calculate.
example
assume dates are in A2,B2, C2 and D2.
Assume process 1 at 1 day, process 2 as 2 days and process 3 at 3 days.
enter 4/3/08 in A2
formula for b2.....=A2+1......results = 4/4/08
formula for c2.....=B2+2.......results = 4/6/08
formula for d2.....=C2+3......results = 4/9/08

Time is a tad different becasue the pc keeps track of time as a decimal part
of a day.
1 hour = 1/24 of a day or 0.041666667 of a day (or rounded 0.0417)
1 minute = (24x60) or 1440 minutes in a day or 0.000694444 of a day.

you can fomat the cell to display hours and minutes but the math must be
done in decimals. you can't add 12 hours to 1 day. you have to add .5 day
Adding times can get tricky.

Regards
FSt1

"Dr_Sabbath" wrote:

I have a spreadsheet that tracks production of an assembled part. I manually
enter in the dates starting from left to right of the start of assembly of
the part to testing, and other associated functions. the last date entered is
the expected date that the assembled part is placed into stock.

Knowing the start date and how long it takes from finish to end, can I
create a formula to enter in the start date and have the spreadsheet
extrapilate fill in the associated dates to completion baseed on seperate
functions of assembly?