next business day

V

Vato Loco

I have a sheet that calculates expiration dates on loans. They ar
entered as 7, 15, 30 days, etc. However, sometimes the expiration dat
is a Saturday or Sunday. I need a way to have it bump 2 days if it is
Saturday, 1 day if it is a Sunday. Below is the formula I am currentl
using:

=IF(B4=120,"120 day lock, exp:"&TEXT(D11,"mm/dd/yy (ddd)")&" sen
confirm to:"&$A$1&" @"&$C$1&" ph: "&$B$1,"")

(d11 is the expiration date destination cell)

Please help if you can....Thanks

Vato Loc
 
R

Ron Rosenfeld

I have a sheet that calculates expiration dates on loans. They are
entered as 7, 15, 30 days, etc. However, sometimes the expiration date
is a Saturday or Sunday. I need a way to have it bump 2 days if it is a
Saturday, 1 day if it is a Sunday. Below is the formula I am currently
using:

=IF(B4=120,"120 day lock, exp:"&TEXT(D11,"mm/dd/yy (ddd)")&" sent
confirm to:"&$A$1&" @"&$C$1&" ph: "&$B$1,"")

(d11 is the expiration date destination cell)

Please help if you can....Thanks

Vato Loco
Click to expand...

=WORKDAY(LoanDate+DaysToExpiration-1,1)


If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.



--ron
 
T

Tod

You can use the WeekDay function. First you'll need to
install the Analysis ToolPak add-in. To do that:

Go to Tools on the menu bar. Then select Add-Ins. From the
dialog box check Analysis ToolPak and click OK.

Once it is installed you can use a formula like this:
=IF(WEEKDAY(D11)=1,D11+1,IF(WEEKDAY(D11)=7,D11+2,D11))
Then point your formula to a cell containing that formula.

tod
 
Top