Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula to Calculate Contractor monthly Spending with Varying End Dates

126 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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