Hello,

Need your help regarding excel formula.

I have one excel data. In Column "D" I have dates. I want to write a macro
which can put some kind of word say as "Yes" in Column "E" if below criteria
fulfils.

1. Say if I am pulling report on 08/06/2009 & day of this date is Monday so
I want data for 04/06/2009 (Thursday) & 05/06/2009 (Friday).

2. Say if I am pulling report in 09/06/2009 & day of this date is Tuesday so
I will require data only for 08/06/2009..this should continue until Friday...

Please let me know if you want a Demo file so I can arrange the same.

Kam.