I determined the formula works but just not on the Excel version I have, once I run the code on a newer version of Excel it ran correctly.

Thank you for help provided