So I'm trying to find the number of days between dates but based off data in another row. For example, in the below image, I want the 3rd row to auto populate based on what date and letter I enter in the first 2 rows.
The number of days calculated is from the date in the same column, to the last date of the same letter in row 2.
So, cell D3=D1-A1, E3=E1-B1, F3=F1-D1, and G3=G1-C1.
I figured it'd be a good starting point to get the last column that contains the same text, but can't seem to get this figured out.
Any help is much appreciated. Thanks!
Screenshot 2020-11-24 150509.png
Bookmarks