Get instant live expert help on How do I calculate business days in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula to calculate adding 5 business days to a date in another column.
Solved by S. H. in 30 mins
Column A "Date Received" Column C "Priority" is validation list with options P1-P6 Column D "Due Date" .. How do I make Column D calculate the due date, based on which option is selected in Column C in conjunction with the date in Column A? PI = Date Received P2 = Date Received P3 = Date Received + 1 day P4 = Date Received + 5 business days P5 = Date Received + 14 business days P6 = Date Received + 30 business days
Solved by D. U. in 14 mins
I need a formula to count business days verses calendar days
Solved by I. J. in 24 mins
Hello sir, I am business man & engaged with the business of soft drinks ie PepsiCo. In this regard I Maintain my stock in excel Sheet but excel not Calculate the bottle ie ( 1box contain 24 PC's)it Calculate the in format of 100 . please help me to dissolve the issue.
Solved by S. E. in 30 mins
Calculate number of days between two dates in Excel ?
Solved by S. B. in 15 mins