You're correct, there is no formula function for this.

To accomplish this you would have to convert your workbook to a macro-enabled workbook and use VBA. You up for that?