Get instant live expert help on I need help with end of 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

My working hours are from 9am to 6pm excel has four fields START DATE S,TART TIME AND END DATE END TIME NEED TO CALUCLATE WORKNIG DAY excluding weekend and calculation of working hours and minutes
Solved by M. E. in 12 mins
Hi there. I run a doggy day care business. I use one "master" spreadsheet to pretty much run the entire business! I need help with 3 of the individual worksheets within the master spreadsheet that need to be interconnected with formulas. I have attached a stripped down version of the spreadsheet and added note to explain what I would like. Thanks!
Solved by A. E. in 21 mins
I have a list of names of class attendees for a 5 day course. Some attended every day, some only a day or two. I am wanting to use some formula/function to pull from each of the lists for each day, and return a single list at the end of the name of each attendee, but only have it listed once.
Solved by K. H. in 17 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
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