I have data which is exported from my system which includes the job date and gross profit amount. I want to find the gross profit total for each day based on a matching date. However, the data exported includes the time in the date cell and Google Sheets won't match it. I'd like to avoid using a helper cell if at all possible.
You can see the formula here
https://docs.google.com/a/advantagep...#gid=780088323
Formula is on the Q column.
Bookmarks