| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two digit week numbers in VB
Hi everyone.
I am currently using the following code to obtain two digit week numbers in excel. Is there an easier or cleaner way of doing it? If Len(DatePart("WW", Now())) < 2 Then _ maxDate = DatePart("YYYY", Now()) & " 0" & _ DatePart("WW", Now()) _ Else maxDate = DatePart("YYYY", Now()) & " " & _ DatePart("WW", Now()) _ Thanks, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering 16 digit numbers - last digit turns to zero | New Users to Excel | |||
| 16 digit numbers | Excel Discussion (Misc queries) | |||
| Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
| what is the minimum numbers set for 4 digit numbers from 0000 to 9 | Excel Discussion (Misc queries) | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Threaded Mode
