I AM TRYING TO WRITE A FORMULA THAT WILL RETURN ONE OF THREE RESULTS. I HAVE
TRIED ALL DIFFERENT WAYS TO WRITE IT, BUT HAVE COME UP SHORT AND VERY
FRUSTRATED...

I WANT THE FOLLOWING TO HAPPEN IN CELL N177:
1. IF CELL(I177) IS BLANK, I WANT IT TO CALCULATE THE DIFFERENCE BETWEEN
TODAY AND THE DATE ENTERED IN CELL F177 PLUS 6(DAYS).
2. IF TODAY IS GREATER THAN OR EQUAL TO THE DIFFERENCE BETWEEN TODAY AND THE
DATE ENTERED IN CELL F177 PLUS 6(DAYS) THEN CELL N177 SHOULD READ AS
"SUBMITTED".

I HAVE BEEN SUCESSFUL AT WRITING THIS PART...AND IT READS AS FOLLOWS
=IF(ISBLANK(I177),(NETWORKDAYS(TODAY(),F177,$D$13: $D$106)+6),IF(TODAY()=NETWORKDAYS(TODAY(),F177,$D $13:$D$106)+6,"submitted")

I GET INTO TROUBLE WHEN I TRY TO ADD THE THIRD COMPONENT:
3. I WANT TO LIMIT THE NUMBER THAT N177 SHOWS TO A MAXIMUM OF "5" (DAYS)
(I.E., IF THE DIFFERENCE BETWEEN TODAY AND THE DATE ENTERED IN CELL F177 PLUS
6(DAYS) IS GREATER THAN OR EQUAL TO 5(DAYS), IT SHOULD READ AS "5"(DAYS).

THIS FORMULA COMPUTES THE ANSWER TO NUMBER 3:
IF(NETWORKDAYS(TODAY(),F177,$D$13:$D$106)+6=5,"5" )

I CANNOT FIGURE OUT HOW TO STRING THESE ALL TOGETHER AND STILL GET THE
RESULTS I DESIRE.

PLEASE HELP!
THANK YOU IN ADVANCE FOR YOUR HELP!