Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel_Macro
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel_macro | Excel Discussion (Misc queries) |