I am trying to get dates to populate cells

[cra1gyb]

I am using 2007.

I have 10 processes that need to happen each on their own days i.e. 1 process 1 day.
These process happen by inserting (1) into any of cells (A1 - J1) depending on which processes are happening. Not all the cells have to be populated.

The next 10 cells (cells K1-T1) have the workday date inserted through a formula(where I am looking for the help)
The due date for the project is in the last cell (u1)and =(X)

This is where the formula begins

process(A1)(1)=date(K1),process(B1)(1)=date(L1),process(C1)(1)=date(M1) etc.
If (A1) is populated with a (1) then (K1) will have a date inserted.


So working backwards as the last task is done the day before the due date. from (U1) in (T1) I want the date to be (U1)-1 should (J1)have a 1 in it.
If (J1) has a (1) and (I1)has a (1) then( T1) must =(U1)-1 and (S1) must =(U1)-2
If (J1) has nothing and (I1)has a 1 then( T1) must =nothing and (S1) must =(U1)-1.
This must go on through all the processes.

Weekends may not be included so dates shown must reflect Monday to Friday and display the date.

Thanks for the help.