Create Workbooks By Date But Not Weekends

[Logit]

.
The following macro does a good job of copying a master workbook then saving for each day of the month.

1 - How would the macro be edited to exclude weekend dates ?

2 - How would the macro be edited to exclude specified dates in a list (holidays) ?

Thanks

Please Login or Register  to view this content.

[Marc L]

1 - Use VBA function Weekday.

2 - Use Application.Match (See MATCH in Excel help) …

[Fluff13]

How about

Please Login or Register  to view this content.

[maras_mak]

Hi, You can also do it like this.
The range named "holidays_" is on the sheet.

Please Login or Register  to view this content.

Regards.

[Logit]

.
Thank you all for your assistance. Greatly appreciated !

[Fluff13]

Glad we could help & thanks for the feedback