“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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?

Solved by K. Y. in 22 mins

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

Solved by T. F. in 13 mins

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.

Solved by M. J. in 22 mins

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

Solved by D. F. in 21 mins

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.

Solved by G. D. in 26 mins

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?

Solved by Z. C. in 16 mins

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?

Solved by A. H. in 11 mins

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.

Solved by C. S. in 19 mins

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

Solved by F. H. in 14 mins

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.

Solved by G. C. in 17 mins