Comments by thewebman555 (Top 1 by date)

losmac, thanks for taking the time to reply.
You are correct in admonishing me on the use of 'cell' as a variable and I have made the correction in my code.
I could not get the suggested formula array to work correctly as the 'range' of dates is not consecutive like from 1/1/2012 to 3/31/2012.
I'll try to explain further.
Each cell can contain a date. These dates represent vacation days for an employee. They may take three days here (3/1, 3/2, 3/3) and another three here (6/16, 6/17, 6/18). I needed to determine how many of those fall on a Saturday. From what I could determine, the suggested formula deals with a defined calendar range and not a range of cells that contain out of order dates.