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