Generate table of weekend dates through VBA?

[andrewf10]

Hi, can someone please give me some inspiration on this?

I need a piece of VBA that will generate a table of all weekend dates for a particular calendar year.

Thanks

 

[Meltdown]

Something like... WHERE Weekday([DateField]) = 1 or Weekday([DateField]) = 7