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
Calculate days between two dates in Excel ?
Solved by S. B. in 15 mins
I need to create a function that will return a date and time that follows business days and business hours
Solved by V. C. in 13 mins