| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format one data series, with error bars, and use it as default | Charts and Charting in Excel | |||
| Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
| How do I make a Custom Datre Format ie 01.01.05 WK1 (WK is Week 1) sorry about previous post | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
Linear Mode
