Calendar
I want Excel to show days like Sun,Mon,Wed in Row2 and below that dates like
1,2,3 if I put a particular month and year in cell a1 e.g. if in cell a1 i put Oct 2007, Excel should show Mon, Tue, Wed in row2 and below that 1 upto month end in row3. At the same time, Excel should colour all values in RED below Colum Sunday. How can I ahieve this? -- Knowldege is Power |
Calendar
hi
http://www.rondebruin.nl/calendar.htm see if this will work for you. regards FSt1 "Ajit Munj" wrote: I want Excel to show days like Sun,Mon,Wed in Row2 and below that dates like 1,2,3 if I put a particular month and year in cell a1 e.g. if in cell a1 i put Oct 2007, Excel should show Mon, Tue, Wed in row2 and below that 1 upto month end in row3. At the same time, Excel should colour all values in RED below Colum Sunday. How can I ahieve this? -- Knowldege is Power |
Calendar
sorry, it didn't help me. I want excel to fill the days and dates
automatically when I change the month in cell a1 -- Knowldege is Power "FSt1" wrote: hi http://www.rondebruin.nl/calendar.htm see if this will work for you. regards FSt1 "Ajit Munj" wrote: I want Excel to show days like Sun,Mon,Wed in Row2 and below that dates like 1,2,3 if I put a particular month and year in cell a1 e.g. if in cell a1 i put Oct 2007, Excel should show Mon, Tue, Wed in row2 and below that 1 upto month end in row3. At the same time, Excel should colour all values in RED below Colum Sunday. How can I ahieve this? -- Knowldege is Power |
All times are GMT +1. The time now is 11:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com