how to filter column by last working day in excel

[AC PORTA VIA]

I work from Monday-Friday and I know how to make macro for Tuesday -Friday (when I can filter by yesterday ) but Monday is the problem as my macro will look for yesterday but that is Sundays data not Friday

 

[Macropod]

Cross-posted at: how to filter column by last working day in excel

Please read our policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[AC PORTA VIA]

Sorry my bad I guess I missed that