Additional info withthe POP up Calendar.
Hello,
I would like this Favour. I want a excel calendar pop up ( I have creatd this) with extra info against each week. I have a formula that I want to put against every week in the calendar. For EG. Our calendar has 13 months and each months has 4 weeks. I have developed this formula to indicate the month and week (eg.1X4, 2X2, 13X4etc) against any date. But what I need is to include this formula in the popup calendar agaisnt every week. such that every week will have this piece of info. whenever I pull up the calendar against any date, I can get the month and week to. Thanks for you help. Vizmeister |
Additional info withthe POP up Calendar.
Here is the formula I want against each week.
=(IF(MOD((WEEKNUM(C3,1)),4)=0,(QUOTIENT((WEEKNUM(C 3,1)),4)), ((QUOTIENT((WEEKNUM(C3,1)),4)+1))))&"X"&(IF((MOD(( WEEKNUM(C3,1)), 4))<0,(MOD((WEEKNUM(C3,1)),4)),(MOD((WEEKNUM(C3,1 )),4)+4))) where c3 will be the monday date in the popped up calendar. On Feb 5, 12:41*am, wrote: Hello, I would like this Favour. I want a excel calendar pop up ( I have creatd this) with extra info against each week. I have a formula that I want to put against every week in the calendar. For EG. Our calendar has 13 months and each months has 4 weeks. I have developed this formula to indicate the month and week (eg.1X4, 2X2, 13X4etc) against any date. But what I need is to include this formula in the popup calendar agaisnt every week. such that every week will have this piece of info. whenever I pull up the calendar against any date, I can get the month and week to. Thanks for you help. Vizmeister |
All times are GMT +1. The time now is 09:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com