I have a google sheet with NHL schedules (hockey). I want to calculate the difference between two games of a specific team.
Example: Nashville played on 2018-11-12 and last game before was 2018-11-10

I know that I can substract the dates manually. But I want to do it with a formular that recognizes automatically, when the last game of a team took place.

Formula should be like this:
= find last game of Team in Column B and substract the date of this event from the actual date of the event.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.