1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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?
  8. 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...
  9. 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.
  10. 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
  11. 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...
  12. 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...
  13. 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...
  14. 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()...
  15. 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...
  16. 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...
  17. 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...
  18. 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?
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

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