Ulisses_Carso
New Member
- Joined
- Sep 4, 2020
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
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 !!!
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 !!!