VBA for printing weekdays in every page

[willy292]

Hi Everyone , if I want to print all the weekdays in between a range , i.e 3 Feb 2017 & 23 Feb 2017,
one single weekdays per every page,for example the first page will be 3 Feb 2017, second page will be 5 Feb 2017
and till 23 Feb 2017, is there any easy way to do that ?
Thanks

 

[GJSBED]

Re: Help: VBA for printing weekdays in every page

Hi Everyone , if I want to print all the weekdays in between a range , i.e 3 Feb 2017 & 23 Feb 2017,
one single weekdays per every page,for example the first page will be 3 Feb 2017, second page will be 5 Feb 2017
and till 23 Feb 2017, is there any easy way to do that ?
Thanks

Have the macro ( I have the date in column A)

Establish the days of the week by referencing the date and using the TEXT function
'=TEXT(A30,"DDD")

Do a logical test for it's weekdayness

'=AND(B30<>"Sat",B30<>"Sun")

If the Result of that test is True then it is a weekday

Filter the spreadsheet to 'TRUE'... hide anything you don't want to see on the paper, and Print it!