Moving a date forward

  • Thread starter Thread starter SPenney
  • Start date Start date
S

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
 
Thanks, it worked perfectly. I had forgotten about some of the dat
functions. I had been trying it with an if statement
 
Back
Top