Returning latest date on certain criteria

Hi everyone,

I'm having trouble figuring out how to write a formula and I'm hoping someone here can help.

Basically within my spreadsheet, the data consists of contract numbers (Column D), Pay Status (Column E), Amount Paid (Column G) and Invoice Date (Column H). The data started on row 5.

What I'm trying to do is find the "latest date" in which the contract number matches, the pay status equals "P" and then return the latest date.

Example.PNG


Using the example, for contract 0111009, it should return 8/31/17. As that is the last date where the pay status is "P". Can someone tell me how I would do this?

Thanks for the help!

I believe I may have figured it out,

Please Login or Register  to view this content.