I want to be able to check when a workflow rule executed and see the result, is there a way of doing this?
Workflow execution goes into the standard debug logs. If you navigate to Setup > Logs > Debug Logs and click "New" on the monitored users list, and start monitoring a user who will execute a workflow scenario (probably yourself, right?) you can then perform the intended action on the relevant record (which depends on your WF object type).
When you have done so, return to the log page and you will see a list of log files generated by these actions - hopefully you can find the right one. In my scenario, I created a new Account, so the action is for the "Account" tab ID basically (and is, of course, the most recent log)
In the log file (click View in the actions to open in the browser) you can find the workflow sections (normally near the end) by searching for "WF_" in your browser. I span up a really simple workflow rule to update a field on Account every time one is created, and this was the log section for it:
Understanding Log files is a developers right of passage ;) but basically, if you read the chunks in capitals, it talks you through the process it is taking;
Even workflow that will not be executed will appear if they are on an object type, only on the lines regarding "CRITERIA" they will say false, and the execution will simply immediately exit. Hopefully this makes sense!