I have been on this a couple of days and I cannot get my head around this ... I use a spreadsheet to track the number of miles traveled by drivers and I want to work out how many miles a driver has traveled between 2 specified dates. Here is the spreadsheet.
Now using this formula I can easily find out the milages I start with.
= MIN(FILTER('Sheet1'!C2:C, 'Sheet1'!A2:A >= START_DATE, 'Sheet1'!A2:A <= END_DATE))
However, if I use a similar formula for the milages traveled up to the END_DATE I do not get the piece of information I need.
= MAX(FILTER('Sheet1'!C2:C, 'Sheet1'!A2:A >= START_DATE, 'Sheet1'!A2:A <= END_DATE))
So let's say I want to find out how many miles the driver traveled between June 18th and June 24 the first formula return the correct value
However, the second one returns the value
without taking account the miles traveled the late shift. Is there a way to get that entry?
Many thanks for all your inputs!