Reducing time between dates in formula to 7 days if over 7

[Jennasis]

Hi again!

Many thanks to those of you that helped out last time!

I have a really tricky one I just can't get my head round fully; I have tried wilcards etc but thus far a bit stumped.

Basically, I need to make a formula calculate the time between dates (in cells N to O & S to Z, Y being automatically the last date in cells S to X) and reduce any time periods between dates to 7 days if they exceed that, then call the file "Closed" if it excedes 56 days in total, unless Y is less than 7 days from today's date... I hope that makes sense...? Cell N has the point of first contact into the business and cell O has the first date received into department.

What I have at the moment is as follows:

Time in Business:

=IF(N4+O4+N(Y4)+Z4=0,"",IF(N4+Z4=0,N(Y4)-O4,IF(N4=0,Z4-O4,IF(N(Y4)+Z4=0,TODAY()-N4,IF(Z4=0,N(Y4)-N4,Z4-N4)))))

Time in Department:

=IF(N4+O4+N(Y4)+Z4=0,"",IF(O4+N(Y4)+Z4=0,TODAY()-N4,IF(N(Y4)+Z4=0,TODAY()-O4,IF(Z4="",N(Y4)-O4,Z4-O4))))


My attempt at a solution was as follows (epic fail):

=IF(N4+O4+N(Y4)+Z4=0,"",IF(O4+N(Y4)+Z4=0,TODAY()-N4,IF(N(Y4)+Z4=0,TODAY()-O4,IF(Z4="",N(Y4)-(O4-(IF(X4-W4=>7,x4-(W4+7),X4-W4)-(IF(W4-V4=>7,W4-(V4+7),W4-V4))-(IF(V4-U4=>7,V4-(U4+7),V4-U4))-(IF(U4-T4=>7,U4-(T4+7),U4-T4))-(IF(T4-S4=>7,T4-(S4+7,T4-S4))),Z4-O4))))))


Many Thanks!

Jenn