workdays

  1. 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...
  2. 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
  3. 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...
  4. 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)...
  5. A

    Counting down workdays - how to stop at one?

    I want excel to count down the remaining workdays I have, and so far it works like this: =NET.WORKDAYS.INTL(TODAY()+1;A47;"0010011") Green = returns the date today Orange = the last date of work this month (I can a list of working hours on the same spreadsheet) Blue = days at work is 0, days...
  6. J

    Calculate work hours between 2 dates including saturday (in Excel 2007)?

    Hi, Please help I am trying to calculate work hours between 2 dates including weekends (in Excel 2007)? Details are: H2 - Raised_Date (Includes date and time) I2 - End_Date (Includes date and time) N2 - Start Time (10:30:00 AM) O2 - End Time (10:00:00 PM) In the formula be I am getting correct...
  7. ellyzadg

    Number of Days on each month based on set cut off dates

    Hi guys! Can you please help me to set an appropriate formula to get the number of working days based on the cut off dates. Below is the sample outcome. Thank you! :) Set Cut off Date <colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align...
  8. F

    Workday -2 in VBA

    Hi Am trying to find the code that will bring up the current date -2 business days - ie Today is 25/02/2016 so I need the cell to show 23/02/2016. Monday will be 29/02/2016 so the cell needs to show 25/02/2016. Apologies if this is not clear & many thanks in Advance.
  9. K

    Workday Formula

    Hello, I need help with workday formula to calculate the number of days excluding weekend and holidays. Here is the data for dates: Start Date End Date 12/14/2015 12/14/2015 12/15/2015 12/15/2015 12/12/2015 12/12/2015 12/10/2015 12/11/2015 12/8/2015 12/25/2015 12/10/2015 1/15/2016...
  10. K

    workdays formula

    Hello, I need help with counting days from current days using workdays formula where I need to exclude all weekend and holidays. My start date 12/07/2015 I need the number of days to current excluding holidays and weekend. there are 5 days in work days. here is the holiday list...
  11. D

    Time Between Workdays in Calculated Column in Power Query

    Hello. I'm having a hard time with the power query language. I need help making my calculated column to show time between two dates but only using workdays. I currently only have the two date/time columns being subtracted. = Table.AddColumn(#"Renamed Columns1", "Overall Approval Time", each...
  12. R

    Calculate end date based on in between workdays

    Hi, I have a sheet where I have a start date and a number of work days to add to that start date. On that sheet I also have information if i should count Saturday and/or Sunday as workdays. I am looking for a formula to calculate the end date based off of the total days to add to the start date...
  13. K

    Need Help with Calculating Due Dates

    I have spread sheet where I am tracking due dates for different deals: See below data I am using: Lender Name Contract Date Due Date ABC, Inc 08/05/15 Tom 08/10/15 David 08/11/15 Tim...
  14. C

    Calendar Issue

    I am trying to build a pretty basic mileage log in excel. I want column A to be a date in a month, for example 7/1/2015. The problem I am having is how do I get excel to know to skip weekends. For example, 7/1/2015 was a Wednesday. I want to drag that date down but I want excel to know that the...
  15. A

    Increase percentage each day between a date range

    Hi, I've been scouring the internet to find a solution to my problem but I haven't found one yet. I'm looking to increase a cell by 4% each day between a set date range (workdays would be preferable). I've tried formulas using TODAY() and NETWORKDAYS, but I can't seem to get my head around...
  16. B

    Help highlighting adjacent cell ten business days (exclude holidays) after the date found in the cell beside it

    Hello, I have been trying to work on this with conditional formatting for a couple of days now to no avail :( Here is a photo of the chart I'm working with: I have made it so that every time a "FILE NUMBER" is entered the cell to the right in grey shows the date it was entered in dd-Mmm-yy...
  17. J

    Amount of Working Days Left in Current Month

    I'm working with PowerPivot and DAX and what I need is to write a Calculated Field that will return a single number that is the number of workdays left in the month. I have a date table included with an IsWorkday calculated column which returns a 1 for a workday (Monday-Friday) and a 0 for a...
  18. dchaney

    Counting Workdays in Access

    Hello all, if this was answered already I am sorry. I did a search and did not find anything. Anyway, I have to create a report on a weekly basis for a customer. Currently I do this in Excel, but I pull all of the data from access. So to save time I am trying to set it up to pull the info and...
  19. F

    Rolling Date excluding weekends

    I'm totally unsure what the solution to this is so please if there any suggestions it would be greatly appreciated :) I'm trying to have a two week rolling dates, starting on the Monday and continuing until the following Friday, this is fine if static but when the start date is then Tuesday...
  20. E

    Need formula to list/populate workdays horizontally (automatically) after inputting the first day of the month into a cell

    https://docs.google.com/file/d/0Bx7rpNe017qjQm1ObTBCMlYxek0/edit?usp=sharing Any idea how to accomplish this? I have tried several formulas (I.E. Networkdays.intl), however I cannot figure it out. I would appreciate any help. Thanks

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top