No, it's not a common question, it's fairly unusual to do this sort of
thing.

Your formula  is a simple  string. You can shape it any way you want to. For
this, you're looking at simple string manipulation using simple VBA.

Yesterday's date is found by subtracting one  from Date(). If you need it in
a specific format, use the Format() function.

The actual row/column name of the active cell  is retrieved by
ActiveCell.Address.