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.
Friday, February 23, 2018
yogi_use QUERY to pull a specific day of the weeks information from a timestamp
How do I use =QUERY to pull a specific day of the weeks information from a timestamp
How do I use =QUERY to pull a specific day of the weeks information from a timestamp submitted by google forms. That way I can make a Monday-Friday set of cells on another sheet and have the correct information for that day pull into it. I've been using this formula and changing it here or there where needed, but I cannot figure out what I would need to do to make that jump to a more complex formula.
=QUERY('Master Layouts'!A2:I,"Select *")
I'm very new to using Spreadsheets and have mostly been able to get by with premade stuff I've found online so far. Any help would be greatly appreciated.