K
Kamlu
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.
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.