working days

1. Formula to Determine How Many Days From a Specified Date Range Appear in a Different Date Range?

Hi All, I have a list of events with start date and end dates (sometimes these are single day events) but I need to know how many working days appear in a certain month. For example someone has taken a holiday from the 29th of January to the 5th of February 2021 this is 6 working days but only...
2. VBA to exclude holidays on list of working days between two dates

Hi I have a code to list all the workdays between two dates, works great. What I need is to add some code that will do the same thing, but ignore any holiday dates held in a seperate sheet "Holidays" as well as weekends. Sub WorkingDays() Dim FirstDate As Date Dim LastDate As Date Dim...
3. Countdown based on two columns

Hi All, I'm looking for a formula that will create a countdown so my team know how long they have to review certain data. All cases need to be reviewed in four working days at the latest. Column A contains the date & Time the case was submitted. Column B is for the initials of the person...
4. Calculating leadtime subtracting specific days/times

Hi all, I have seen many questions have already been asked regarding calculating leadtimes and related topics, but I was not able to find the answer to my specific question. Therefore I am opening a new thread. I f my question has already been posed and answered, i apologize and kindly ask you...
5. counting working days in specific months between two dates

Hello! I need to calculate the number of working days (no Saturdays and Sundays) between two given dates, but i would like to exclude the working days from June, July, August, and December. A1 is the start range 10/1/13 B1 is the end range 4/3/2015 Thanks for your help!!
6. Using date formula in conditional formatting based on working days

Hi I am trying to create conditional formatting in Excel 2007 to highlight a cell based on its value in comparison to today's date. I have a cell (B1) which has a value of TODAY(). I want to express conditional formatting for a range of cells (B4:J90) which all have a date value in them. I...
7. Calculating working hours between 2 dates with a SharePoint twist!

Hi, I have read post upon post related to this topic but unfortunately none of them produce the effect I am hoping for. Hopefully someone with more excel knowledge will be able to provide some helpful hints! What I am looking for: I need to calculate working hours (Monday-Friday) between 2...
8. Calculating Workdays

Hello, I am needing some help calculating the number of working days between two dates, with the number of working days per week being variable. Not sure Excel has a built in function for this? I have checkout out weekday, workday.intl, and networkingdays, but they do not offer exactly what I...
9. Create custom calendar

I need to get in Excel 2003 the following: a) Automatically create a calendar table for each year, as shown below in my example for 2012. b) Conditional formatting (coloring) Saturdays, Sundays and public holidays. c) Calculate working (business) days in B40. I've created separate sheets (one...
10. Help with Dates

Good afternoon. I am looking for a formula which gives the amount of working hours between 2 dates. Working hours are monday - Friday and 10am - 6pm Any help would be very much appreciated. Thanks
11. Dates of working days in a month

Is there anyway that I can populate the list of dates (only working days) in a month? For example: Cell A1 has the drop down list of all the months (Jan to Dec) Cell A2 has the drop down of year (2011, 2012, 2013, ...) If I select "Dec" in A1 and "2011" in A2, then column A3 should have the...
12. Distributing 6 Working Days Across Months

I have 2 column headings for a beg and end date. I have 12 column headings for all 12 months. I need to type in the beg/end date and then have excel put in the # of working days (6 INCLUDING Saturday) in the related months. I've been able to use one for 5 days, but I NEED 6. Any help would...
13. Use WORKDAY style function using a 6 day week

Hi, I am tring to find work out dates going backwards using the WORKDAY function excluding holidays. This works fine apart from it omits Saturdays and I want to include them. The only things I need to omit are Sundays and public holidays. Can anyone help? I have a cell (E1) with my first...
14. NETWORKDAYS and Different workdays

Hello, I am using the NETWORKDAYS function. Is there a simple way to have working days changed from Monday-Friday to Sunday-Thursday? I know it can be done using sumproduct and an array, but I thought maybe there would be an easier way. Thanks.
15. Help with a formula

This is a excel question, I posted in the wrong area.. sorry.. I need something simple to figure out set number of working days from the time an employee is hire for evaluations. new employees that are hired work 4-day weeks I need something to let me know when they hit the 30-working day...

This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back