How to get the Week-Number?

[theToaster]

I am trying to get the number of the week for an agenda I'm creating.

I thougt about
(month*30+day )/7 = weeknr
but I am getting rounding probs then...

Does anybody have a better Solution, through which I get the actual week-number?

thx
This message was edited by theToaster on 2002-09-04 12:51

 

[Aladin Akyurek]

On 2002-09-04 12:51, theToaster wrote:
I am trying to get the number of the week for an agenda I'm creating.

I thougt about
(month*30+day )/7 = weeknr
but I am getting rounding probs then...

Does anybody have a better Solution, through which I get the actual week-number?

thx
This message was edited by theToaster on 2002-09-04 12:51

=WEEKNUM(A1)

where A1 houses a date.

WEEKNUM is part of the AnalysisToolpak add-in, which you can activate via Tools|Add-Ins.

 

[Tanner]

Click on Tools, Add Ins and select Analysis Toolpak. That toolpak has a function called WeekNum that you can use.