Thanks Mike, Chip and Rick :-)
It's interesting to see three versions of tackling the same task - and the
notes made it much easier to see what's going on.
Thanks a million :-)

"KevHardy" wrote:

I have used the workday function to populate column A with just workdays
(also used a named list of holidays to exclude).
I was wondering if anyone had a bit of vba to automate this process?