View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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