How to create a sequence of dates?

[arrun]

I would like to create a sequence of dates (only weekdays) from 01-01-2012 to 31-12-2012 except few defined dates (can be treated as official holidays.)

Is there any specific function available with VBA to do it easily?

Thanks for your help.

[Kenneth Hobs]

=Workday