work days

Hello, I am having trouble calculating a time difference between 2 x calculated dates taking into account workdays / weekends and working hours. Could someone help me coming up with a working formula? I have tried NETWORKDAYS - but don't know how to account for working hours. My problem is that...

I need a formula or macro I enter a “start date” say 1/5/2022 use count +28 in a different cell I get 2/2/2022 use count +14 and get 2/16/2022 then repeat in the pattern of +28 / +14 this is how I got my work schedule for the year ( I’m a sailor )…I need to pull days worked per pay period...

I am trying to create a WORKDAY.INTL formula that only includes Monday, Wednesday and Thursday excluding Saturday, Sunday,Tuesday and Friday. I am having a little trouble getting the "pattern" down. This is the formula I have but it is excluding Sat, Sun, Tue, Thur instead of Sat, Sun, Tue, Fri...

I am currently using a calculation from an older post to calculate end date time using a start date time and a duration. This formula excludes weekends and accounts for a 18hr production day...

hi, Id like to save a work book using a name of indexpricingDDMMYY, but where the date is the previous business/working date. I'd ideally not like to reference a cell in the workbook, just use function like workday-1 or something? I am able to save with the current date-1, but this does not...

Hello, I have been trying to work on this with conditional formatting for a couple of days now to no avail :( Here is a photo of the chart I'm working with: I have made it so that every time a "FILE NUMBER" is entered the cell to the right in grey shows the date it was entered in dd-Mmm-yy...

Hello, I am setting up a time sheet for my employers to use. There are 7 days in a week but I want to set it up in such a way that the user can only input work hours for 5 days a week and prohibit them from inputting anything on the other 2 days. For example, if Employee A worked Mon-Fri, then...

Hi all- i'm stuck on a problem: I need to calculate the 3rd friday of a given month, but if that date is a holiday (based on an array of predefined holiday dates), then I need to return the previous good workday (i.e. if Friday & Thurs are both holidays, return Wed.). I can calculate the...

I have 2 column headings for a beg and end date. I have 12 column headings for all 12 months. I need to type in the beg/end date and then have excel put in the # of working days (6 INCLUDING Saturday) in the related months. I've been able to use one for 5 days, but I NEED 6. Any help would...

Hello, thanks for looking at this for me. I have laid out the scenario as best I can below (apologies for the poor text formatting). I've got a series of individual files (all formatted exactly the same) containing data. These are located in specific directories. I have one consolidation...

I'm trying to determine how to calculate lead time based on work days. Initial Date: 6/1/09 (Cell B66) Lead Time: 72 business days (Cell C68) X: This is what I'm trying to solve for, which would be 72 business days from B66 (Cell D68). Desired output is date format of B66+C68 with only...