Formula Required

[cra1gyb]

I have a due date for a product required in cell A2.(31 May 2011). There may be up to 10 different processes that need to take place in order to manufacture this product. Each process required takes 1 Day. Should the process be needed I would populate the cell with a "Y" leaving every second cell to contain a formula to insert the date needed for that specific process. If the process is not needed then I just need to work backward from the due date required 1 day at a time. I need to get a date for each process populated with a "Y" working backward 1 day at a time from the due date.

Thanks

 

[shadow12345]

Im not sure I quite understand your quesiton. It might help if you posted and example spreadsheet showing what it is you want to do (don't worry about the formula just type what you want in each box.) The stickies on the board can tell you how to post the spreadsheet on the board

If all you are looking for is the date to go forward by one day if you write "y" in the cell then this works.

=IF(B2="y",A2+1,"")

(This goes in C2, it checks if B2 has a "y" if it does then it adds one day to the date in a2)

 

[cra1gyb]

where I am getting stuck is if there isnt a "Y" in B2 or in C2 but there is one in D2 then this must produce the result of A2+1.

If there is a Y in B2 then it must add 1 day onto A2.

If there is a Y in B2 and C2 then it must add 1 day to B2 and 2 days to C2.

This needs to go on for about 10 processes where there may or maynot be a Y and where there is a Y it need to add 1 day from the last Y.

Hard to explain.

 

[shadow12345]

Yes i does sound tough to understand...

This in L2 would add one for every "y" between b2 and k2

=A2+COUNTIF(B2:K2,"y")

Is that what you are looking for? Or are you trying to have it go Y/Date/Y/Date/Y/Date (/being another column)

 

[cra1gyb]

Thanks for your Help. That seems to be working out.