Edit date formula

[dlee70]

I am looking for some help with editing a long winded formula. I have attached a worksheet with the formula on so it can be viewed.

The idea is that a date is entered in Column I, and column AA shows the date +28days. When a date is added in Q or V the clock stops until a date is added in S or X. The number of days is added to AA.

The problem I have is if the date in S/X is less than 7 days before the date in AA, 7 days from S/X needs to be displayed in AA.

The formula also references AG, but I can't work it out of the formula.

Any help would be greatly appreciated my sleepless nights!!!!

Edit - There is a 28 day period. Within the first 21 days entering dates in q/s & v/x don't affect AA. If the dates entered in s/x are day 22 onwards, then 7 days needs to be added from the date in s/x.

The dates in q/s & v/x show that papers are being edited so "stopping the clock" until returned.

It currently looks like the below but I think it is more complicated than it needs to be.

=IF(I1=0, " ",IF(IF(OR(S1<Q1,X1<V1),"Yes",IF(((I1+28)+(S1-Q1)+(X1-V1))-X1+AG1<7,X1+7,(IF((I1+28)+(S1-Q1)-S1+AG1<7,S1+7,(I1+28)+(S1-Q1)+(X1-V1)+AG1))))=28,TODAY(),IF(OR(S1<Q1,X1<V1),"Yes",IF(((I1+28)+(S1-Q1)+(X1-V1))-X1+AG1<7,X1+7,(IF((I1+28)+(S1-Q1)-S1+AG1<7,S1+7,(I1+28)+(S1-Q1)+(X1-V1)+AG1))))))

[Aardigspook]

Welcome to the forum.

I'm sorry, but I don't quite follow the logic you need.
AA is I + 28. That's fine.
A date is added in either Q or V and 'the clock stops' - what do you mean by that?
If a date is added in R or T, 'The number of days is added to AA' - what 'number of days'? The number of days between I and Q, I and R, Q and R, something else? Or the number of days between I+28 and Q or V or R or T? What happens if there's a date in both Q and V or R and T, but they're different?
Not only does AG appear in the formula, but there's a V128 in there as well, and TODAY(). Plus 'Yes' appears to be one of the possible answers from the various IF statements. Where do these all fit in?

Can you try to explain again what it is you want?

[dlee70]

Edited. Any help appreciated

[Glenn Kennedy]

Try this out:
=IF(OR(S2+7>=I2+28+IF(S2="",0,(S2-Q2))+IF(X2="",0,(X2-V2)),X2+7>=I2+28+IF(S2="",0,(S2-Q2))+IF(X2="",0,(X2-V2))),MAX(S2,X2)+7,I2+28+IF(S2="",0,(S2-Q2))+IF(X2="",0,(X2-V2)))

I tghink it meets all your criteria...

[dlee70]

Thank you. However if the dates entered in S and X are within 21 days of I, then AA needs to stay at I+28. If the dates entered are 22 days onwards, then AA needs to be S+7 or x+7. The date in x will always be later than s.

[Glenn Kennedy]

Isn't that what it does???

1) 28 days + stoppage times (maximum 2 occasaions)

2) If any restart time is <=7 days away from 1), then it returns 1) PLUS 7.

If that is not what you want, you need to supply more expected results from selected inputs.