Re: $$Excel-Macros$$ Simple Excel Calendar

2011-10-30 Thread Haseeb Avarakkan
Hello Siti; Simple & a nice formula. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

Re: $$Excel-Macros$$ Simple Excel Calendar

2011-10-30 Thread Aamir Shahzad
Dear Noorain/Setiyowati, Can you brief below mentioned formulas how these are fetching data & generating calendar. Aamir Shahzad On Sun, Oct 30, 2011 at 8:14 PM, NOORAIN ANSARI wrote: > Great Setiyowati, > > Excellent Formula..Mind blowing > > > -- > Thanks & regards, > Noorain An

Re: $$Excel-Macros$$ Simple Excel Calendar

2011-10-30 Thread NOORAIN ANSARI
Great Setiyowati, Excellent Formula..Mind blowing -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Oct 30, 2011 at 8:25 AM, STDEV(i) w

Re: $$Excel-Macros$$ Simple Excel Calendar

2011-10-29 Thread xlstime
Great ..very simple and easy On Sun, Oct 30, 2011 at 7:10 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Simple Excel Calender. > > =TRANSPOSE({1;2;3;4;5;6;7}) > > =IF(MONTH(F10)<>MONTH(F10-WEEKDAY(F10)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}),"",F10-WEEKDAY(F10)+{0;1;2;3;4;5}*7+{1,

Re: $$Excel-Macros$$ Simple Excel Calendar

2011-10-29 Thread STDEV(i)
Another *Array Formula* for Simple Calendar (MultipleResult Array Formula on 7 columns X 6 Rows) based on Date in a cell F22) grid formula =$F$22-WEEKDAY($F$22)+COLUMN(1:7)+ROW(1:7)*7-7 weekday name formula =TEXT({1,2,3,4,5,6,7},"ddd") On Sun, Oct 30, 2011 at 8:40 AM, NOORAIN ANSARI wrote: >

$$Excel-Macros$$ Simple Excel Calendar

2011-10-29 Thread NOORAIN ANSARI
Dear Group, Please find attached Simple Excel Calender. =TRANSPOSE({1;2;3;4;5;6;7}) =IF(MONTH(F10)<>MONTH(F10-WEEKDAY(F10)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}),"",F10-WEEKDAY(F10)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}) Press ctrl+shift+enter with both formula -- Thanks & regards, Noorain Ansari *htt