workday

I am working on a time card template in excel. I want to use a formula to determine if the date in Column A is a workday (that is not a weekend, Sat / Sun, and not on our list of holidays/closures) I was looking at the Workday function but it did not return a true/false value it just returned a...

Is there a way for the Workday Worksheets to reflect the user system settings of the date format? Currently our report administrator had "hard formatted" the date format to: mm/dd/yyyy However, we have a mixture of global employees, some of them have date format dd/mm/yyyy. This creates a...

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

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

Hello Everyone, 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...

Hi there 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: https://exceljet.net/formula/date-is-workday 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...

Hi. = Workday(A1,1,[holidays]) 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: https://www.mrexcel.com/forum/excel-questions/1107696-approximate-match-vlookup.html I want to amend this formula: =IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0)),"Y","N") to this...

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

Hi I have set-up the below but the LEN calculation seems wrong as LEN that isn't 15 is matching and doing the workday function. Can anyone see what is wrong please?

Hello everybody! 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 <tbody> A B C D E F 100 150 20 70 50 01.01.2019 02.01.2019...

I need help with a formula please to calculate the number of working days between two dates, I'm not sure how to use the WORKDAY function or even if that's the correct way to go.

Hi, I am looking to use CF to show how many working days have passed from TODAY RED - 3 or more ORANGE - 2 YELLOW - 1 GREEN - TODAY Any help appreciated Thanks

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