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!”
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