With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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
Very specific query to pull from specific workdays.
I am stuck trying to use a query to pull a very specific data set from another sheet.
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.
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.