Additional info withthe POP up Calendar.

[vizmeister]

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

 

[vizmeister]

Here is the formula I want against each week.
=(IF(MOD((WEEKNUM(C3,1)),4)=0,(QUOTIENT((WEEKNUM(C3,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.