1. 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...
  2. 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...
  3. S

    Adding a row after last instances of dates

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

    Random value must be unique depending on date range

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

    Color cells if workday and holiday (VBA)

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

    Vlookup with file path in table array

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


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

    Combining If and Workday function

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

    Count the number of "TRUE" cells in an adjacent field in a table?

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

    Day or Arrival, Plus 2

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

    possible to have WORKDAY FUNCTION holiday range to include time stamp?

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


    An extension to this problem: 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...
  13. E

    Workday formula required based on depending dates

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

    Len if and

    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?
  15. J

    VBA - Copy Paste in last workday

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

    Working days calc

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


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

    Datepicker, Default to previous workday

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

    Calculating Dates to End on Friday or Monday if Original Date Ends on a Weekend

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

    Excel function = WORKDAY

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

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