Help

Formula to Calculate Contractor monthly Spending with Varying End Dates

562 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mariah_Parks
4 - Data Explorer
4 - Data Explorer

Hey everyone, hoping someone can save the day.
I’m trying to calculate the month to month and YTD spending for each of our contractors. I’ve calculated the workdays (holidays excluded) from start date and I have their hourly and daily pay rates. My issue is varying contract end dates. Some contracts have ended already and some end dates are blank because they’re still active/current. How can I get an accurate calculation for billing per month & year?

0 Replies 0