Creating reports based on the date ranges

It is time to learn how to create a report based on the custom date range with the help of  query function in google sheets.This will be a very helpful lessons for every one who loves to work with google sheets.

image 01

Assume that we have a large data table as shown as above image 01.So if we are able to select the data according to a given date range then it will be very useful in our day today activities.To do this we have to design a report template as shown in the below table(image02).

image 02

Query is entered to the A5 cell and we use C3,D3 cells to input dates.For date cells we can use date picker to select dates easily.

For A5 cell we enter following formula.

=iferror(query(Data!A2:F,"where A >= date'" & text(C3,"yyyy-mm-dd") & "' and A <= date'" & text(D3,"yyyy-mm-dd") & "' "))

image03

Once we entered the query to A5 cell,it is time to give desired date range to C3 & D3 cells.Then query extract details from "Data" sheet according to the given date range.

Google Sheet reports using query function