Custom Format for WEEKNUM(Today())

[Guest]

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?

 

[Arvi Laanemets]

Hi

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


Arvi Laanemets

 

[Guest]

Thanks...

This solved my problem.

Hi

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


Arvi Laanemets