I have two sheets in an Excel workbook. The first is a list of contracts for workers A, B, and C and the contracted revenue rate per day.
In the other sheet, I would like to calculate the number of days each worker (A, B, C, etc.) (ignore the Revenues in the image) is under contract during the given period. What formula would I use to do this?
Add columns with the period date on the right of your first table. Then under each period's end date, insert eh following formula:
And populate to fill the table
The for your second table, use the following formula:
If you want to have the number of days times the rate calculated, use the following formula in the second table: