Hi, Adam-
I know it can be done with VBA, but I'm not sure about a formula. If
you get no answers feel free to contact me at
Cyclezen(at)yahoo(d0t)com. The VBA code is simple and direct.

Dave O