48 Hour Alert Formula ( Help )

[fstopblues365]

Hello,

I need a formula that will look at a date and spit out a date 48 hours later. Here's my problem, It has to exclude the weekends?
Here is the formula I'm currently using, however it seems very accurate excluding the weekends.
=IF(WEEKDAY(I25+5)=1,I25+6,IF(WEEKDAY(I25+5)=7,I25+7,I25+4))

Example with the above formula:
Variable Date Out Put Date
11/4/2015 it gave me 11/8/2015

So it did not exclude the weekend, Your help with this is much appreciated.

Thanks in advance!

 

[Eric W]

Have you tried the WORKDAY function?

=WORKDAY(I25, 2)

 

[fstopblues365]

Eric,

Prob Solved.. Thanks!

 

[Eric W]

Glad to help. Excel has so many functions, no one can keep track of them all.