Help with extracting dates out of brackets: complication...

Hi Guys,

I am not sure if this is possible at all - give it a shot anyways.

The issue is that column O extracts the date out of column N, however at row we encounter a problem where there are 2 brackets information in a cell, therefore excel gets confused and throw back a #VALUE! - would I be able to let excel know I only want it to grab information from what's in the second brackets ie date date?

Or any other way for excel to capture only the date data from the cell it reads from? It's been bugging me for a while now.... Since using all formula/function in column O and P I'd only to use formula/function without VB or macro.

Is it possible?

Thanks in advance for looking and attempting to solve this issue.; )