Thank you GeneralDisarray - I'm trying to stay away from VBA for simplicity of other users of this spreadsheet.

Tony - it could be both, but it'll likely be a a date and a number. Could you explain the impact of both on your solution?