SUMIFS of a value that falls between a rolling date range
I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns:
JSH *job site hours*
What I need is to calculate the sum of total JSH if the job falls within a specific job type AND is scheduled from TODAY and three weeks out. This data set will change and feed a dashboard to see within a rolling 3 week period how many hours are being scheduled within that time frame.
=SUMIFS([Estimated Hours Number]:[Estimated Hours Number], [Job Category], "Customer", AND([Planned Start Date] = Today),([Planned Start Date] <=3 weeks from today)) <= not sure how to set that date calculation
Help Article Resources
Check out the Formula Handbook template!