View Single Post
  #1   Report Post  
RonB
 
Posts: n/a
Default Custom Format for WEEKNUM(Today())

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