Jeremy Member

This worked. I misread that and applied false but true cleared it up. Thanks for the help.

I did try that as well thinking that may solve my issue but then I see all the dates. I'd like it to just show the two dates with the amount of revenue for the week and not the whole month.

I should have thought of that. That's perfect. Thanks so much for the help.

Correct. I'm trying to do it all within there as I am making some other changes as well.

That worked well. Thank you for the help.

I'm using average as the formula is for a summary number. I need it to give me the average time spent on site during the prior week. The way I have it (I think) is it's taking average of Time Out - Time In. The average parentheses is set up to enclose both the time out and time in). I tried using the provided formula…

Took a bit (have to love huge files) but this is working. Thanks for steering me in the right direction.