# workdays

1. ### Workdays Formula for GANTT CHART

Hey All, Can any one please help me out with the Workdays formula for attached excel Sheet. I don't want the weekdays. Like you can see the attached file that it says weekdays in =E2-WEEKDAY(E2,1)+2+7*(E4-1) Can any one please help. https://ibb.co/71yvZTc...
2. ### SUM of cells that contain data

Hi everyone. Boring to count all the cells contain data. I have a worbook where marking my workdays and workhours. Once a year i have to calculate my workdays in SUM. In workbook have sure have for a year 12 worksheets. Any solution of formula for last month of year in separate cell ? Some...
3. ### Display Workdays ONLY

Hi there, The code below displays / outputs a list all dates between a specified starting and ending date input by the user. However, I'm having a bit of trouble only listing WORKDAYS (Monday through Friday). An added BONUS would be to also eliminate Holidays from the list. Any advice or...
4. ### Calculate number of working days (excluding holydays) month by month

This is to calculate # of workdays per month in a project A2 and B2 I´ll have start and end dates, c1 - q1 I´ll have the months (jan-dec) holydays will be on a named array sized 2cx8r. thanx
5. ### Macro for keeping timings between workday times

At the moment i have been using long if statements to keep the work times of jobs within the working day. I was wondering if there is some vba code which would allow me to set the hours of my work day and then when the job time is added to my start time only stay within my set times and carry...
6. ### Count Workdays in Excel 2010

Hi Lookingfor some help please I have a tab in a separate sheet linking to the Master Sheet.Four columns in sheet Col A. Date Started Col B. Date Complete Col C. Did itmeet <90 days Col D. Link to column C (Yes, No but if date equals 00/01/1900then NUM!) Col E. Start of Month – 01/10/2018...
7. ### Date calculation for workdays

In G4, I have my start date. In H4, I have my end date. In I4, I need the number of WORKDAYS between the start and end dates. I know how to calculate the difference between the two dates. I don't know how to get workdays. Thanks, DJ
8. ### Subtract number of working days, from a date

Hi all, You've all been so helpful in the past, so I thought you might be able to help me out once again. I'm trying to work out lead times based on a cut off date, I need to subtract the lead time (Column B) from the cut off (Column C) to calcualte the last order date (Column D), however I...
9. ### Calculate number of workdays since a date

Hi experts - I'm looking for a macro to calculate the number of work days since a date (when a document was signed). Below is columns F and G from the workbook. <tbody> Document signed date Workdays since 01-January-2018 15-February-2018 </tbody> Now, I know that this can be fairly...
10. ### today + 3 workdays

Hello guys, How do I go about setting a cell to show a date 3 workdays from today? =DATE(WORKDAY(TODAY,3)) or something?
11. ### Using WORKDAYS formula with "Holiday" range - not calculating correctly

Hiya I have read through the forums, but can't seem to find an answer to my unique situation.... Action: I need to calculate 5 working days after a date and include holidays Formula: Using workdays formula and named my holiday range pubhol18 (I have also tried just selecting the range)...
12. ### Copy / Paste range of cells based on number of workdays in a month

Hi all, I have a range of data (A3:J26) that I want to repeat in a single tab. Each set of data would be for each workday of a given month. (I have 12 tabs, so I would do this for each month) So what I would like a formula to do (please not VBA or macro) is the following: For the...
13. ### Semi-monthly Pay Date with Different Pay Period

Payroll for my company is semi-monthly. The workdays 8th - 23rd are paid on the following 1st. The workdays 24th - 7th are paid on the following 15th. How do I use =today() to determine its corresponding payroll date? I've created the following that appears to work. Is there anything simpler or...
14. ### Workdays due and overdue

Hi, I am looking to find a way to calculate the remaining workdays between 2 cells/dates and keep them counting when the date has past. So the following: A1: Start Date B1: End date C1: Either working days left or days overdue Today is Feb 14th: A1: 01-02-18 B1: 08-02-18 C1: -4 A1...
15. ### Alternate between workdays and weekends in stacked bar chart

Hello I am trying to have just the workdays appear in the stacked bar chart that is found in this template: https://www.vertex42.com/ExcelTemplates/task-list-template.html Is this possible?
16. ### January 1st Holiday with WORKDAYS formula

Hi, I'm new to the boards. So hoping you can help me. I'm using the WORKDAYS formula to calculate due dates for my tasks. I've entered the holidays in the correct format (=Date(YYYY,MM,DD)). The formula will work with the holidays for all except New Year's Day, 1/1. Not sure why. Any...
17. ### Speed up workbook calculation

Hello I have an excel file that is very slow on calculation, due to the followings: The excel file is a collection of information, all the workers in a departement ( col A, alfabetically sorted ) and a 3 month forecast of the holiday columns ( C-BP (workdays from Jun-Aug) ). and there are 4...
18. ### count number of workdays exluding holidays in 2016 between 09/01/2015 and 09/15/2017

I need to count the number of workdays exluding a list of holidays in 2016 between 09/01/2015 and 09/15/2017
19. ### Account for weekends in a =IF formula

Team, Working on a spread sheet that is calculating the expected return date by number of pages and date turned in. Current formula: =IF(I3<=0,"",IF(I3=5,"2"+B3,IF(I3<50,"3"+B3,IF(I3>=50,"14"+B3)))) Formula breakdown IF(I3<=0 (Zero pages to keep the "FALSE" from appearing) IF(I3=5 (5...
20. ### Formula for working days

Hi All I'm hoping someone can help. I'm trying (and failing), to make a formula which adds 2 hours to a column which includes the date and time. Some example dates: 11/11/2015 13:49 12/08/2015 16:36 13/09/2015 07:50 14/10/2015 11:17 The formula has to take account of working days (Mon-Fri)...

### 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.

### Which adblocker are you using?

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