workday

  1. 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: https://exceljet.net/formula/date-is-workday Now I want to create a new field...
  2. 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...
  3. 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...
  4. T

    Workday

    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...
  5. 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...
  6. 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?
  7. 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...
  8. 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.
  9. E

    Workday

    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
  10. 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...
  11. 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...
  12. 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...
  13. D

    Determining work days and date ranges (Gantt related)

    I'm working on a gantt chart where I want to be able to determine the number of "work days" which occur as of a certain date (which could be a weekend or holiday start). I have to subtract non working days such as holidays, which are listed in another tab. The function I am using is WORKDAY()...
  14. M

    Scheduling in Excel (How to skip weekend and holiday)

    Hi I would like to make a basic scheduling in excel. So here is what I want to do: The Completion time simply= Start time + Process timeThe start time formula = The last process time.What I want to make is, how to make the completion time skip the non-working hours and days. For example in...
  15. A

    Need last workday with Mon's & Tue's off

    Hello all, I have this formula in B1 to find the last workday of the month having Mondays and Tuesdays off: =WORKDAY.INTL(A1,NETWORKDAYS.INTL(A1,EOMONTH(A1,0),3)-1,3) which goes down the column to B12, with A1:A12 varying from A1=01/01/2018 to A12=12/01/2018. It all works well except for Jan...
  16. L

    VBA: Using a WORKDAY formula that references the cell above

    I'm working on a scheduling spreadsheet that has evolved over time The relevent data is a date in column 7 (G) & the build time in minutes in column 12 (L) Part of the macro that runs on this sheet includes some code kindly provided by JLGWhiz The code divides the biuld time by 426 (1...
  17. D

    Calculate Pay Day

    Calculate pay day I get paid on the first of every month. When this falls on a Saturday or Sunday I get paid on the previous Friday. But when this falls on a Bank holiday I get paid on the previous working day. How do I calculate my pay day?
  18. J

    Continuous days tally not including weekends

    Hello, I am trying to get a continuous running tally of days that does not include weekends. I used a formula to check if the date is a weekend, if true, return 0, else, add 1: =IF(WEEKDAY(L5,2)>5,0,L7+1) I am able to get the weekend as 0. However, the tally reverts back to 1 after the...
  19. B

    WORKDAY Formula

    I am trying to figure out a formula for adding 30 days to a date and if it lands on a SAT/SUN it going to the previous WEEKDAY assuming there is not a holiday. For example Date: 1/23/18 +30 is 2/22/18 which is ok because that is a Thursday but Date: 2/2/18 + 30 is 3/4/18 is a Sunday need it...
  20. 3

    First Workday of the Month

    Hi, I have seen many articles or posts on the internet that using the following formula, I could get the first workday of the month. =WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-1,1) However, the result of the formula is 43040. It doesn't make sense to me. Do I need to convert it first...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top