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.