Thanks...

This solved my problem.

"Arvi Laanemets" wrote:

Hi

Something like this:
=TEXT(WEEKNUM(A1),"00")


Arvi Laanemets


"RonB" wrote in message
...
I am using WEEKNUM in Excel to do some COUNTIF functions and have problems
with matches because Excel returns a single digit rather than 2 of weeks 1
throuhg 9 of any given year. Using teh COUNTIF function 20051 then
mathmatically is the same as 200510. Is there some way to format the week
returned to be 2 digits?

--
RonB