Take a look at http://www.cpearson.com/excel/weeknum.htm at ISO week numbers

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rainey" wrote in message
...
Not really,
I tried to use the formula WeekNum. It calculated up to a 53 week, and
then
there was no week 1! And, I'm trying to do fiscal year 2005, and not
2004,
but with the week sum, it shows 2004 and 2005.
The reason 2004 data is in there is because week #1 is from 12/26/2004 -
1/1/2005
I had to copy Dec 2004 data and now it is throwing off my 2005 fiscal
totals.

"Bob Phillips" wrote:

Is this what you mean

=INT((TODAY()-A2)/7)+1

--
HTH

Bob Phillips

"Rainey" wrote in message
...
I am trying to take a date range 6/26/2004-1/31/2005
and get it to return a specific week number in the 52 weeks. Our
accounting
week #1 starts at 5/26/2004-1/1/2005. And so on. I NEED it to return
the
"1" for this week range, or "2" for week #2 range. How do I do this?