workday function

  1. S

    =Workday, first day being weekend

    Hello, I'm a bit confused with the function workday. So i use it to find the working days of the month, Excel is configured to have saturday and sunday as weekend days. However i realized today that, for the 1st of June 2024, ie 2024/06/01, which is a saturday =WORKDAY(DATE(2024;6;1);0) does...
  2. C

    Workday in VBA

    I want to add 30 weekdays to a date instead of 30 days as is in my existing code but can't quite figure it out. I've set up the following: Sub WhyWork() Dim d1 As Date, wf As WorksheetFunction Set wf = Application.WorksheetFunction d2 = wf.WorkDay(Date, 30) End Sub But I need to insert...
  3. C

    workday help

    I've been trying to update some old spreadsheets that add 30 days to a date to instead use workday to add 30 working days. I've managed to convert my old dates into the correct dates using workday however, when I do it in that order it completly messes up my pivot tables later. Is there a way of...
  4. xlhelp15

    Return the Workdays

    Hi Expert - Would need your kind assistance for the below condition. Column A2:A5 has dates in mm/dd/yy format and Column B2:B5 has 10, 15, 20, 30 respectively. In column C2:C5, I would need an output which should return the Workdays date by adding it. For eg, if A2 has 09/21/22 and B2 has 12...
  5. J

    Subtract 3 business days from date

    In column A every cell is a different date. In column B, I want to put in a date that is three business days prior to the date in the other column. For example, if A2 date is 6/5/2022, cell B2 needs to be 6/1/2022 (three business days prior). I need a macro that fills in every cell in column B...
  6. H

    VBA IF function with If True add one workday to previous row cell

    Hello, I'm trying to embed an If function in VBA code but get stuck with several elements of the piece code (functions / brackets etc). The correct code for cell I2 would be =IF(H2=H1;WORKDAY(I1;1);F2) Could someone help me to build this specific line of the code? Appreciated! Hans Grandia...
  7. D

    Working day of each month

    Hello guys, Can you help me with this one, I need to pupulate the 'calendar' with the same task that is due on 'each specified working of the month' ie, every 4th working day is x and every 15th working day is y... At the bottom of the table I have left the 'numbers' in as they show the NEXT...
  8. T

    workday with exceptions

    Hi all, Thank you for spending your time to read the post. I have some questions regarding the excel. I am in the process of creating an excel workday calculator. The issue is 1. There are some working saturdays 2. There are some non-working holidays (which i grouped under public holidays)...
  9. R

    Exclude start date while calculating number of work days?

    Hello Everyone, Greetings for the day! I'm looking for the solution in calculating number of days in which start date could be excluded. Note: putting "-1" in function will not work as I'm already excluding Sundays and Holidays. If work starts on Sundays or on any holidays "-1" will further...
  10. J

    Date Picker - Validation to only allow workdays

    Hello, I have a User Form with a DatePicker. I want to Add validation so that only future workdays can be selected (excluding both weekends and Holidays). Date Picker name = DTPickerLaunch Validation occurs on command: Private Sub CommandButtonContinue_Click() List of Holidays is located...
  11. J

    Sum Billable Hours by Week by Team

    I've been looking around but can't seem to find out how to sum billable Hours by week by teams. Information that I have. All Dates are already calculated as workdays (Mon-Fri) Each row has a different Task that is performed. Below is the layout of my information. E2 = Team name I2 = Total...
  12. J

    Include the Start date in WORKDAY caluclation

    I'm having trouble figuring out the offset for my WORKDAY formula so that the Start date is included in the calculation. I know I can change the number of days to account for this (use 0 instead of 1) but Long story short the higher-ups want to see the 1 as it does, in fact, take a 1 day...
  13. K

    Conditional Formatting w/ Multiple Criteria involving Workday

    I'm using Excel 2013. I have a column of "Closing Dates". I need anything in that column dated today to highlight in red, 3 days in the future highlighted in green, and 5 days in the future highlighted in yellow (anything older than today has no highlighting). The RED formatting is easy...
  14. B

    Count workdays since a date

    Hi guys - I'm confident this is an easy fix but I can't seem to crack it. I'm looking to calculate the workdays since another particular date. I'm sure its NETWORKDAYS and TODAY but I'm struggling. The first date is column D and days since is column E and the table is currently 50 rows...
  15. A

    Formula to apply time loss

    I am stumped with this. I have due dates for my assignments. I would like to apply a 1% penalty for every day they are late. The formula I have been trying to get working is: =IF(TODAY()>Report!D12,F8-((TODAY()-Report!D12)-((WORKDAY(Report!D12,(TODAY()-Report!D12)))-TODAY()))*0.01)...
  16. T

    Adding months to a workday function including holidays

    Hello, I am trying to use a workday.intl function to determine a date 6 months in the future that is constrained by holidays. Here is my formula =WORKDAY.INTL(F5,EDATE(F5,6),"0000000",$T$2:$T$521) F5 =9/5/17 the formula is returning 6/8/2136 Does any one know what is causing this error?
  17. N

    Need to calculate start date

    I have a table to track machine hours needed and the date and hour an order is due. I'd like excel to return required start date and time in a cell. My workweek starts at 12am on Sunday and ends at 8pm on Friday. Due date is in column E, runtime hours in column f, I need required start date in...
  18. T

    A max end date for WORKDAY.INTL

    Hello, I am using a WORKDAY.INTL function to determine a due date. Is it possible to have it stop at a certain date. This is my formula =WORKDAY.INTL(B55,10,1,C$77:C$104). If the due date is going to fall after 6/10/15, I would like it to stop on that day. Is that possible? Thanks,
  19. T

    Conditional Formatting

    Hello, I have a WORKDAY.INTL function that returns a due date given parameters (thanks DRSteele). Now I am trying to conditionally format the cell so that the default return date (Wednesday February 29, 1900) is invisible. I have tried conditional formatting as a date, as number, as text will...
  20. T

    Additional parameters using the WORKDAY.INTL function

    Hello, I am using the following formula to determine a due date (you have 60 days to complete the assignments including weekends and excluding holidays) =WORKDAY.INTL(A1,60,"0000000",C1:C9) A1 = start date 60 = number of day to complete the assignment “0000000” = every day is included (no...

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