Get instant live expert help on I need help with excel business days
“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 count business days verses calendar days
Solved by I. J. in 24 mins
Is there a formula that counts business days?
Solved by E. F. in 24 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
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 have three columns, 1st = title of project. 2nd = project due date. 3rd = expected completion date. I need to use conditional formatting to color the title for each project either green (if expected completion date is 30 or more BUSINESS days before due date), yellow (if expected date is between 30 and 15 business days before due date), or red (if expected date is 15 or less business days before due date).
Solved by T. Q. in 13 mins