
0
Good Morning!
I'm seting up a metrics spreadsheet with a lot of formulas. The person who will be administering it in the future isn't really familiar with formulas so I'd like to make it as easy as possible. I created a formula that does what I need =COUNTIFS({Date Reported}, >=DATE(2018, 11, 26), {Date Closed}, <=DATE(2018, 12, 2))
Rather than include the actual date in the formula I would like to reference a table of dates in the same or a different sheet. For example, is there a way to say =COUNTIFS({Date Reported}, >=DATE(Week 1, Start Date), {Date Closed}, >=DATE(Week 1, End Date))?
Start Date End Date
Week 1 11/26/2018 12/02/2018
Week 2 12/03/2018 12/09/2018
Week 3 12/10/2018 12/16/2018
I'm thinking this would allow the administrator to maintain the dates for each week in the table versus dealing with formulas. If anyone has another solution that would be great too.
Thanks for your help!
Comments
Mike Wilday
December 6, 2018 9:08 am
tina.walter@ma…
December 6, 2018 10:19 am
Mike Wilday
December 6, 2018 10:42 am