Need a formula to help roll over #’s if it is past a certain day and question on password protection

Okay first thing: password protection. I added it to my sheet that is in a cloud that the entire company has access to. This information is semi confidential. How protected actually is it? And do I need to take more steps to protect it? It is info about pay for specific employees that make bonuses based on a percentage of signed contracts. They need access and my boss needs access but no one else.

Next: I have 2 days workbooks. One with the basic information that transfers onto the protected workbook via query. So in the password protected workbook, I am trying to calculate the bonuses. For example, the data collected is how much the payment was and who did the assisted the contract. They get 5% of that payment. However the contracts can stretch til months in advance. For example: I have one where the consult was created in January and the signing is in February. The data from the consult is in January but there is no confirmation on if it is signed. But they need to be paid on a monthly basis. So is there a way to make a formula that adds up what has been marked as true but then cuts off and stops working after a date (like Jan). So then is it possible to make another one that carries over what is left and adds it together so that if it is signed in March or another month, they will get paid for that contract in that month? If you have any questions or need clarification please ask. I am new to excel and want to figure this out