Max function between dates

J

Jay

Have a spreadsheet, Column A is every day ( dates, Jan 01,
2003, Jan 02, 2003 ect.... ) Column B is how many emails
where sent that day. Im trying to automate a function

Max( # of emails sent in last 30 days, 60 days ect.. )
The table is updated weekly and trying to make it
completly automated so i dont need to switch the formulas
every week

Can anyone help me, if any additional info is needed post
questions

Thanks in advance !

Jay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
sum columns between certain dates 1
Summing rows based upon condition 2
Adding days to the WORKDAY function 2
Function that groups together Overtime hours by 7.5 hrs 2
Function Problem 6
Max-Min with specific criteria 1

Top