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
|