Hi Experts,

Quick and small help required. I googled quite a lot for this but was unable to find any.

I want to input the Yesterday's Business Date on a range of cells say for E.g from column L2-L59.

Two criteria's are important.

1) Should be yesterday's business date. I.e. If today is 08/06/2014 then my the code should update as 08/05/2014. If i am running the code on a Monday, then it should update the date as friday.

2) The range can vary. Today it might be from L2-L59, tomorrow it can be L2-L70.


Can you please help.