Find out expiration date based on counters and dates

[Ulisses_Carso]

Hello everyone, I've been trying to make a formula here for a few days, but so far without success.

I have a spreadsheet with different contracts, dates and codes,

These contracts have a counter determined by the codes of one of the columns, when a certain code appears the counter adds "+1", that counter in turn has its validity determined by the column of dates, being 30 days.
When the codes pass 30 days, the counter decreases.

I am trying to find a way to determine when the accountant will expire, that is, when the contract will "disappear" from my spreadsheet.

Therefore, I need to create a column showing the contract counter and another column with the (future) date on which they expire.

So far I have failed miserably to achieve any results and my deadline is expiring, so I am asking the community to help me with this problem.

I did not find here a place to attach an example file, if there is a possibility tell me where I attach it.

Thank you for your attention and effort in advance !!!

 

[smozgur]

I did not find here a place to attach an example file, if there is a possibility tell me where I attach it.

You cannot attach or upload actual files as samples. However, you can post sample data by using XL2BB, and it is the best way of exchanging sample ranges between the board and the Excel application. Helpers can easily transfer the range to Excel instead of trying to create the same structure in a worksheet manually, and also include their mini-sheets in their replies.

An alternative might be uploading your file to some cloud service that you can share, but we don't recommend doing that since it wouldn't be safe to open a file that is downloaded from the Internet.

You can also read the Posting Aids section on the Guidelines help page.

In any condition, please do not share any sensitive data.