Account for weekends in a =IF formula

[bfriday]

Team,
Working on a spread sheet that is calculating the expected return date by number of pages and date turned in. Current formula:
=IF(I3<=0,"",IF(I3=5,"2"+B3,IF(I3<50,"3"+B3,IF(I3>=50,"14"+B3))))

Formula breakdown
IF(I3<=0 (Zero pages to keep the "FALSE" from appearing)
IF(I3=5 (5 pages turned in),"2"+B3(date pages turned in +2 days)
IF(I3<50(less than 50 pages turned in),"3"+B3 (date pages turned in +3 days)

How can I have excel account for the weekends to give an accurate return date of just working days?

v/r
B.Friday

 

[dreid1011]

Check out the =WORKDAY() function and see if that works for you.

Also, I believe the "" around your numbers to add may be unnecessary.

=IF(I3<=0,"",IF(I3=5,"2"+B3,IF(I3<50,"3"+B3,IF(I3>=50,"14"+B3))))

 

[bfriday]

dreid1011,
I don't quit understand how to plug it into my current formula to account for it. Do you have an example?

 

[dreid1011]

dreid1011,
I don't quit understand how to plug it into my current formula to account for it. Do you have an example?

Okay. Untested, but try this:

=IF(I3<=0,"",IF(I3=5,WORKDAY(B3,2),IF(I3<50,WORKDAY(B3,3),IF(I3>=50,WORKDAY(B3,14)))))

There is an optional argument for this function as well, if there are certain holidays you want to exclude from the calculation.

 

[dreid1011]

Also, what should it be if I3 is 1-4? Your <50 condition will trigger on those values as well.

 

[bfriday]

Thanks!!!!!!

 

[bfriday]

The documents are turned in with 5 or more pages, no 1-4.

 

[dreid1011]

Thanks!!!!!!

You're welcome, happy to help.

The documents are turned in with 5 or more pages, no 1-4.

Ah, got it.

 

[dreid1011]

Here is a much more concise version:

=IF(I3<=0,"",WORKDAY(B3,LOOKUP(I3,{5,6,50},{2,3,14})))