# Get instant live expert help on I need help with next business day

“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 to change date to next business day 5am if date/time stamp is past 6am. Example Tue 13-Feb 6:01AM would need to be Wed 14 Feb 5am
Solved by K. W. in 23 mins
I need a formula in column 'S' that looks at a 'date & time' in column 'R', and if the time in 'R' is after 4pm, I need column 'S' to populate with a 'date & time' that is 8am of the next business day.
Solved by A. A. in 18 mins
Need help with British Gas/Business Gas/Scottish Gas as they can pay three different ways 1. if D2="British Gas/Business Gas/Scottish Gas",C2="British Gas/Business Gas/Scottish Gas" then minus 180days from G2 AND USE EOMONTH 2. if D2="British Gas/Business Gas/Scottish Gas",C2="does not =British Gas/Business Gas/Scottish Gas" look at date in B2 ,IF DATE IS >01.02.2018 THEN USE THIS CODE WHICH IS THE MAIN CODE '=IF(E2="Pending Reg",EOMONTH(G2,1)+0*(DAY( ETC
Solved by B. H. in 16 mins
Hi I am using today function in my cells.but next day it changes the date automatically. How do I lock the day
Solved by G. B. in 25 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