Daily manpower

Isaac A

I am having trouble creating a consistent formula to track how many workers will be on site for a given day. Based on the start, end time, and count of manpower for each task, I have used that as a reference for a SUMIFS() formula in a separate column. I have also added a date column that shows a list in ascending order of dates until reaching the finish date. The formula created works for the first date which is the start date. For any other day a result of zero will appear. Here is the formula that I have so far.

SUMIFS(Manpower3:Manpower38, Start3:Start38, @cell >= [Work Day]@row, Finish3:Finish38, @cell <= [Work Day]@row)

I have even tried to lock in the range for manpower, start, and finish and still result in zero. If anyone has a solution it will be very helpful.

Paul Newcome

Why exactly are you specifying rows 3 - 38?

How exactly is each data point being entered?

Have you double checked that the date columns are in fact date type columns?

Paul Newcome

Are you able to provide some screenshots for reference?

Isaac A

Paul Newcome

Why exactly are you specifying rows 3 - 38?

How exactly is each data point being entered?

Have you double checked that the date columns are in fact date type columns?

Isaac A

There are not any formulas for Start ,End, or Workday because I removed the formulas. Man power is calculating a sum of the columns to the right for the worker type for each Task. Yes I have checked that the columns are in the correct format.

Man Power = SUM(LABORER@row:WELDER@row)

Paul Newcome

I just realized that the formula you posted and the formula in your screenshot do not match. The formula in your screenshot has the operators reversed for the dates. The formula you posted should work.

Isaac A

The formula works as long as the finish date is equal to the start date. Is there another operation to get the formula to calculate the days in between two dates?

Isaac A

Thank you Paul for responding to the discussion post I have figured it out.