Get instant live Excel expert help with WORKDAY Function

I want to find the date by adding the number of working hour as well as date using formula Workday or Workday.intl. Can you explain to me the workday definition?

I need to create a dynamic input/output tab based on a variety of variables. I need it to by dynamic and lookup certain values based on others and compute a start/end date. I need the processes (input value) to be kept in a prioritized list and allocated evenly over the employees in order to minimize time spent on all of the projects. Any help/advice you can provide would be great! I want to populate start/end date in the input tab based on the following criteria: Employee: I want to look up employee based on cells A3:A6 in the same tab, Factor # from B3:B6 in the same tab people per process from the same sheet (D15:D33) And I want to match the people with the process time (I have a separate column for each I want the start date and end date to populate starting with the first one being manually entered (9/1/17) and the 1st process has to be the one with Priority #1. I want the processes to allocate in order and evenly distribute among the employees based on their factor allocation time (For example if it's process # 9, it has priority 7 so it should only be started once all other tasks are assigned with no more tahn 2 tasks assigned per time (want this # 2 to trace to a cell where I can change). So let's say FTE #1 gets the task, the time would be 29 MD from the start date so you;d have to loop it through the excel workday function with holidays included (have an example in resource allocation tab) We also have to consider the constraints of the start/end date for all employees

I have a schedule I'm doing with formulas to add workdays (across rows) to a start date column. I would like to write the equation like this: =ifError((workday(b2,1) = cell above, [value of cell above + 1] Help me form this correctly to get the (value of target cell) = (1 more than the value from the cell above) IF the target cell value started equal to the cell above.

will this work? =if(workday(b2,1) = c), (c2+1) I'm trying to use excel to figure out networkdays or how many work days in a year

I am trying to use a workday() function in a calendar, such as =workday and all it does is highlight the entire row instead of just the weekends. I would prefer to hide the weekends all together.

i have 4 columns, column1 is 7:30 am column2 is 4:30 pm column3 is 9:00 hrs and that's where the fun ends. i would like column4 to do this... 730am to 430 pm = 9hrs - (8hr workday) = 1 (red) then can i subtract the red numbers from the black ones, or the hours owed (red) against the hours worked (black) and determine if i owe the company hours, or if the company owes me...make sense?

Until recently my Excel online job progress sheet worked perfectly using the WORKDAY function to calculate due-dates. But now for some reason it only returns #VALUE despite the date formats on all columns and rows being the same. Please help? Should I be using work day or workday?

I have a attendance tracker spreadsheet and need to change net workdays to include Saturday as a defined workday and can't figure it out.

setting automated date formula (with spaces between rows), so that target workdays doesn't have to be adjusted manually.

Sheet 1: Calculate the average based on workdays -Monday, Tuesday, Wednesday, Thursday, Friday. Refer to Column N for where the solutions need to be. We need to find the average amount of times something is being prepped according to the day of week.