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:
Dim d1 As Date, wf As WorksheetFunction
Set wf = Application.WorksheetFunction
d2 = wf.WorkDay(Date, 30)
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...
Hello again all. My brain hurts trying to figure out this one. I have a spreadsheet of all open orders, listed by date. I'm trying to find the last instance of a workday date, insert a row, format the row, and add text to the first cell. I can get the formatting part pretty easily, the tricky...
Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created.
I would like to have only unique random values per week, and a minimum of 2...
Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox.
The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells).
Is there a way to...
Hi, this is the vlookup I currently have (that works)
VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0)
The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...
My office use Workday. The database has an undocumented sick report we run at the end of the month. However, each month we manually delete the Rolling occurrence that falls off. I would like to create a report that will take the download excel report and add to and delete the...
I’m trying to make a spreadsheet for work which will allow me to track daily assessments.
Basically, we either get two types of assessments to do - S17 and S47
mom trying to figure out how I create a formula that generates deadline dates for each assessment from the date it was...
I have an Excel table with a field called TradingDay that simply stores Boolean values of whether a given date is a trading day. I used the formula described here to get whether the date is a trading day or not:
Now I want to create a new field...
I am trying to build a formula in excel that will compare two dates.
I am using =NETWORKDAYS formula to calculate the number of days in between, and that is working great.
My problem is, in Cell C1, I am entering a date of arrival. What I need is:
If the arrival date is a workday, then it...
For the "holidays" I have no problem with my list: (1/1/19, 1/21/19, 2/18/19, etc.).
However, I am making a stock market calendar with different time increments. Sometimes the market closes an hour earlier to observe the upcoming holiday. Thus instead of...
An extension to this problem:
I want to amend this formula:
Hi Team :)
I have below data and im using formula =WORKDAY(C2,1) to calculate the workdate based on the received date.
However, I have 3 depending activities for which the workday should calculate only after the depending task is completed. and it will be next workday after the depending task...
I'm currently facing a relatively simple problem.
I have the following table:
There are values in the Range B2:F2
Then there are a calender column since A5 - like below
OK I have this in my code which defaults the datepicker to todays date but I have tried to no avail to get it to use previous workday as defasult date.
I know this is gonna be simple but here is what I have now which works for today.
PrevRptDate.PrevDTPicker.Value = Date
I have tried a few...
Not sure it it's possible, but is there a formula that will take my date formula of subtracting/adding days to a date (=SUM(B6-65)) a step further to move the date to end on a Friday if the original calculated date ends on a Saturday and move to Monday if it originally calculates on a Sunday. I...
Using workday function to give me T-1 days. So for example if its Thursday, it will return Wednesday based on the function = Workday(Date, -1)
Now Im trying to make this work so it excludes every friday. For example, if on Monday, i want it to return Thursday (not friday)
Any help is...