display a list of dates for the year, but do not include weekends?

[yu]

yu (Visitor) Feb 6, 2001
I am trying to create an array which will display the dates for all the days of year in a row in an excel sheet , however i want it to skip weekends and bank holidays and in the place of the weekends I was to display the work WEEKEND.

eg.
05/02/2001
06/02/2001
07/02/2001
08/02/2001
09/02/2001
Weekend
12/02/2001
etc....


Can anyone give me a few pointers on where to start please????

 

[mrjts]

Can't you just format the date to give back the day of the week and then compare it to "Saturday" and "Sunday". If true, then add "Weekend" to the array every time you hit "Saturday", but do nothing on "Sunday".