Google Sheets How to use the Date Function and how to select data based on a date or today's date
This quick and clear video will show you how to use the date function to make sure all your date information is formatted correctly.
This video then goes on to show you how you can select date from your spreadsheet based on today's date. So if you only want to see data from today for example you can filter out everything else.
HERE are the functions used in the video so you can cut and paste them into your own spreadsheet.
=date(2021,10,7)
=query(Sheet1!A:C, "SELECT A,B,C WHERE B like 'Sandwich' AND todate(A)=date'" & text(today(), "YYYY-MM-DD") & "'")
=query(Sheet1!A:C, "SELECT A,B,C WHERE B like 'Salad' AND todate(A)=date'" & text(today(), "YYYY-MM-DD") & "'")
Here is a link to the spreadsheet so you can make a copy of it and try it out.
https://docs.google.com/spreadsheets/...