Count unique values in Column A, only if value in Column F falls between two dates

Thanks Tony. Perfect.

I will use the formula in more than one cell. I figured that once someone had helped me with working out the formula I would be able to edit it as required to use it in other cells. I notice that the way you have written it I can copy and formula paste it straight into the remaining cells in the table.

Thanks again for your help. Greatly appreciated.

Sritcho