Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
run different macro depending of the day of the week
Hi All,
What i am trying to do is to run different macro depending of the day of the week. For this purpose in cell A1 i typed the formula =now() and then right clicked on cell A1/Format Cells/Number/Category:Custom/and in the Type: typed: dddd . After that in cell A1 is the word Monday. In cell B1 i type this formula: =IF(A1="Monday",1,"") BUT it looks the formula in B1 doesnt recognize the word Monday in cell A1 because after i press Enter cell B1 remains empty not 1 as it should be. I also tried to copy cell A1 and paste special as values in cell A2 and then changed the formula in B1 to =IF(A2= 38789.66795,1,"") but the formula still doesnt work. Does anybody now how to do this? Tim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
run different macro depending of the day of the week
Tim
one way: =IF(WEEKDAY(A1)=2,1,"") This would depend on the settings on your computer. This assumes that Sunday is the first day of the week. Regards Trevor "Tim" wrote in message ... Hi All, What i am trying to do is to run different macro depending of the day of the week. For this purpose in cell A1 i typed the formula =now() and then right clicked on cell A1/Format Cells/Number/Category:Custom/and in the Type: typed: dddd . After that in cell A1 is the word Monday. In cell B1 i type this formula: =IF(A1="Monday",1,"") BUT it looks the formula in B1 doesn't recognize the word Monday in cell A1 because after i press Enter cell B1 remains empty not 1 as it should be. I also tried to copy cell A1 and paste special as values in cell A2 and then changed the formula in B1 to =IF(A2= 38789.66795,1,"") but the formula still doesn't work. Does anybody now how to do this? Tim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
run different macro depending of the day of the week
Works great. Thank you Trevor!!! Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Macro to coppy cells to certain rows depending on value in cell | Excel Discussion (Misc queries) | |||
Editing a simple macro | Excel Worksheet Functions | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |