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

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