Shannon, is it an Excel function or VBA? I've done a lot of Excel work, the majority with VBA.
Just in case; VBA is Visual Basic Applications, a programming language that can be used to automate, secure, connect to database servers, perform advanced calculations, combine and execute functions, and, even formatting of cells, spreadsheets and workbooks.
Let me know if I can be of any help.