Thanks![/QUOTE]

Do you mean there are two header rows, one with the beginning date in say C1, and the end date in C2?

It might be better if you could upload a sample workbook so that we can understand the requirement in context.

Rgds