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
Nothing attached. Try uploading again and don't forget to hit 'Start Upload' and wait for the grey checkmark before hitting 'Submit'.