I have the following data at https://docs.google.com/a/advantagep...#gid=780088323
I'm trying to figure out the average daily revenue. Range L4:L34 would give the total growth. I just need to find a way to find the average based on the amount of weekdays occurred during this month. Not any future weekdays. For example, if L4:L34 was sum of $10,000 and there were 9 weekdays it should return $1,111.12. I figured this formula
to count weekdays in my I4:I34 range. I just need to figure out a way so it doesn't include future dates. Just ones which have already occurred in the current month.