First, I cannot post a sample spreadsheet as it contains confidential company information. Second, sorry I don't really understand your question about before and after. Third, I am constructing a formula for a cell, not using VBA.

I will post back with a clearer explanation of my question.