good afternoon,
I am looking for a formula that can take the Resource Name in in column C and find the day rate on the Reference worksheet.
Then multiple the date day by the number of days working in the month (cols E:O)
Then add that all together in a monthly total in row 19.
Thank you
Sample.xlsx
Bookmarks