More Questions Sums and Averages by Date
How can I set up a formula to calculate the total revenue per month
and the
average turnaround per month? My data is organized below:
What do you mean by "per month"? For example, what if you total revenue for
a job was $1000 and the job lasted from June 1st to June 15th... was your
total revenue per month $1000 divided by 1/2 month ($2000 per month) or
$1000 divided by the total month ($1000 per month)? What about it job
spanned 2 months (May 24th to June 8th)? What if those 15 days crossed from
February into March of a leap or non-leap year?
Rick
|