VBA for printing weekdays in every page

willy292

New Member
Joined
Oct 2, 2017
Messages
1
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

GJSBED

Board Regular
Joined
May 3, 2016
Messages
91
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,100,201
Messages
5,473,129
Members
406,846
Latest member
otown2221

This Week's Hot Topics

Top