1. ### How to replace weekend and capture the next business day

Hello, I have a record with dates that included the weekends in there. I would like to find and replace the weekend days to next business day. <colgroup><col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5449;"> <tbody> #C65911[/URL] , align: right"]1-Jun-2014...
2. ### Networkdays

Hi All, Me and my friend were working on an idea where we could pull total business hours worked excluding holidays and weekends so we started googling and got lucky with this formula =(NETWORKDAYS.INTL(B2,C2,11,A2:A100)-1)*("START TIME"-"END...
3. ### vba query - how do you save a work book with the name of previous working day?

hi, Id like to save a work book using a name of indexpricingDDMMYY, but where the date is the previous business/working date. I'd ideally not like to reference a cell in the workbook, just use function like workday-1 or something? I am able to save with the current date-1, but this does not...
4. ### Networkdays Formula IF/OR Cell has Open or Closed

Hello Excel Gurus! I am befuddled over an IF/OR function in Column M (M2) of Networkdays where if Column L (L2) has "Closed" as a status Networkdays calculates the difference between J2(start date),K2(end date),HOLIDAYS in M2. But if Column L (L2) has "Open" as a status Networkdays calculates...
5. ### Business day interval calculation using WORKDAY and NETWORKDAYS

Hello Excel Gurus, Can someone help with a bus day interval calculation involving WORKDAY and NETWORKDAYS calculations? If the status of the query is "Closed" and the end date is greater than the set interval, then show the number of days the query is late. If the status of the query is...
6. ### Working out business hours from/to specific dates/times

Hello! I am hoping someone can assist with a template they just happen to have kicking around... I need to know the specific business hours from the first date/time to the second date/time, based on: a 9 hour (8-5pm) day a 5 day working week (Mon-Fri), with BC, Canada holiday dates factored...
7. ### Automatically highlight fields with dates that are older than 5 business days?

I have columns of dates and I'm looking to automatically highlight dates that are older than 5 business days from today. Is that conditional formatting? Thanks in advance
8. ### Excel business day turn around help!

Hello all, I'm not too skilled with excel and these threads are helping a bit but I'm not finding exactly what I need. Basically, what I want is a formula that I can input the last email date/time that we responded to at the end of the day and based off our business hours it gives us the...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...