January 24, 2023
After calculating the number of days is there anyway for excel to autopopulate the outcome based on the data input?
I need a formula to be able to tell me whether it is RH, BOP or STP.
The answer will either appear automatically in the Determination box: under SOP path / Evidence Base / Decision table.
For example, if I put in the employment start and end date, and put in the operation start and end date - it will automatically give me an answer whether it is RH or BOP / STP to accept or reject it.
I am sorry to keep uploading it, it's the last attachment is the correct one