Formula for creating week Numbers

[Gary]

I have a spreadsheet for products with a corresponding
release date. I need to create a week number generated
from the release date. Has anyone got any ideas.

Thanks

[Anonymous]

"Gary" <gary....@dwp.gsi.gov.uk> wrote in message
news:018f01c2cb6c$45829f10$8df82ecf@TK2MSFTNGXA02...

Here are two formulas for calculating the ISO week number from a date in A1.
I haven't found any difference in results, so unless anyone can identify any
such, take your pick:

=INT((A1-(DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,3)-WEEKDAY(DATE(YEAR(A1-WEEKDAY(A1
-1)+4),1,3)))+5)/7)

=1+INT((A1-DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,5)+WEEKDAY(DATE(YEAR(A1+4-WEEKDAY
(A1+6)),1,3)))/7)

[J.E. McGimpsey]

Look at the WEEKNUM() function in XL Help. WEEKNUM() is part of the
Analysis Toolpak Add-in, so you'll have to install that to use the
function.

Also, be sure to look here for a discussion of ISO week numbers vs. XL
week numbers:

http://cpearson.com/excel/weeknum.htm

In article <018f01c2cb6c$45829f10$8df82ecf@TK2MSFTNGXA02>, Gary

[Gary]

Thanks

The formula works fine

>.
>