workdays

  1. P

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Some videos you may like

This Week's Hot Topics

Top