Moving a date forward

[SPenney]

I have a worksheet that tracks the processing of bills, that starts wit
the invoice date. I am assuming, on average, 3 days in the mail. W
don't receive/process the bills on Saturday or Sunday.

Assuming that the invoice date is in B1, and the days in the mail is i
A1, I'm am using =$A$1+B1. How can I get those that fall on Saturda
or Sunday because of the mailing time to Monday?

Thanks

Sta

 

[Frank Kabel]

Hi
try
=WORKDAY(B1,A1,list_of_holidays)

 

[SPenney]

Thanks, it worked perfectly. I had forgotten about some of the dat
functions. I had been trying it with an if statement