I have a situation. Lets consider the below example.
Col A Col B
Now I need to have a vba code or formula which will identify the last working day.
eg. if my present working day (Today) is 8-Aug-11 then my last working day was 5-Aug-11. Similarly If the present working day is 2-Aug-11 then last working day should return 29-Jul-2011.
Please help on this.