Week number in excel

[fanch72]

Hi
Can anyone help me defining a funtion that finds the week number for a specific date?
For example, knowing that we are the 06/02 2004, the formula should give week 6
Thanks for any help
Francois

 

[xlbo]

erm
WEEKNUM
think you may need the anlaysis toolpak installed though

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[HansGermany]

Hallo,
there are two ways for looking to a week-number:
a.) by VBA (VisualBasic for Application)
and b.) Normal with the standard-functions

I'm from Germany and I use following standard-functions:

=KÜRZEN((A1-WOCHENTAG(A1;2)+11-("1/"&JAHR(A1+4-WOCHENTAG(A1;2))))/7)

Now I try to translate this one to english:

=SHORTEN((A1-WEEKDAY(A1,2)+11-('1/'&YEAR(A1+4-WEEKDAY(A1,2))))/7)

I do not exactly know the translated name of 'KÜRZEN' in english. I assume this is the function 'shorten' (or similar).

Good luck and success!

Bye!

Hans Porzel
from Steinwiesen / Bavaria / Germany

 

[HansGermany]

Hallo,
I'm back!

I know now the english name for the german word 'kürzen'.

It is 'TRUNC'.

This to the earlier answer a few minutes befor (see above!)

Hans Porzel
from Steinwiesen / Bavaria / Germany

 

[fanch72]

Exellent! Thanks a lot for your help!