Number of days difference according to keyword

[Halidat]

Hello everyone,

I have a list of dates, and a project name next to each of them

I would like to know how to find how many passed since the beginning of the project selected in the dropdown menu, compared to the date of today.

Screenshot 2024-07-28 174909.png

Thank you!

[BadlySpelledBuoy]

Try this for one way.

=A2-INDEX(Data!A:A,MATCH(B2,Data!B:B,0))

You could also use XLOOKUP rather than INDEX/MATCH.

BSB

[popipipo]

=A2-MAXIFS(Data!A2:A10;Data!B2:B10;Summary!B2)

Maybe this will work

[Halidat]

Thanks both, it worked with =A2-INDEX(Data!A:A,MATCH(B2,Data!B:B,0))!

[BadlySpelledBuoy]

Glad we could help

BSB