Hi I want to Filter the previous(Yesterday's) date using Excel Macro
e.g. (today(21/4/2015),yesterday(20/4/2015)).In this I want to filter 20/4/2015.
In this one condition, If Monday comes we want to filter Friday date because Saturday & Sunday no data will be there to filter on that date. So at Monday we want to filter Friday date. For Tuesday, Wednesday, Thursday, Friday we want to filter previous day date.
So please give me solution.