Formula to make Excel count business days/skip weekends?

G

Guest

I'm trying to set up a formula in Excel where I can type in a date and on the
6th day it'll show the due date without counting Saturday and Sunday, only
regular business days, Monday - Friday. For example, I receive a job today
11/17, 6th business day is 11/24.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skip weekends 1
UK Business Days Formula 1
Exclude weekends when counting days only on day 29 or 30 3
Conditional Formatting to Exclude Weekends 4
Triggering a Flag after 10 days that excludes weekends and holiday 3
Finding the right function & formula 4
Count 1
Count Week Of Month 4

Top