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