Sunday, April 8, 2018

yogi_From 'Master Data"!A:E Pull Data For Each Month Based On Months In Columns A and B And Rules Specified In 'Master Data"!G:G

Google Spreadsheet   Post  #2416

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-08-2018

Very specific query to pull from specific workdays.

Hello, 

I am stuck trying to use a query to pull a very specific data set from another sheet. 

Problem: 
I need a query function to pull data from a range of data, inside that range of data are 2 columns of dates. Col1 is a date of a reported error, Col2 is a date when the error was made. The errors are categorized by month but have a 3 workday grace period into the next month, if they are reported in this grace period they are listed in the previous month, if they are reported after the grace period they are counted in the current month. 

E.g: 

Error made on 3/30/2018, reported on 4/4/2018 counts for March and should be listed on March's sheet

Error made on 3/30/2018, reported on 4/5/2018 counts for April and should be listed on April's sheet

Error made on 4/1/2018, reported on 4/4/2018 counts for April and should be listed on April's sheet. 

I have worked around and figured out how to almost do it, but it would require fixed days instead of workdays, and this was reported as unacceptable. 

If anyone can help, I have created a test sheet to share with how the end result of the data should look.

For the final sheet I would like to have the data source be an entirely other sheet if that makes any difference. 

Thank you!