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?