workday function

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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,

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

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

Hello, In excel I am trying to return a date given a "start date", "excluding holidays", and "a number of days for completion". For example, given the start date of 9/1/2015, 60 days for completion, excluding holidays, would be XX/XX/XXXX. The "WORKDAY.INTL" function would be great, but I do...