PDA

View Full Version : How to create a sequence of dates?



arrun
10-02-2012, 10:42 AM
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
10-02-2012, 11:08 AM
=Workday