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?