| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
On Sun, 06 Feb 2005 12:29:51 -0500, Ron Rosenfeld
wrote: The solution depends, in part, on how you are defining the week number. Some years can have 53 weeks. If you are using the standard ISO definition the year will always be in this century then week/year entries are entered as numbers then the following VBA routine should work. Actually, the week/yr entries (i.e. 0406) can be entered as text, also. VB will coerce it into a number. --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 4 Day Work Week in a formula | Excel Discussion (Misc queries) | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
| Formatting dates in a formula | Excel Worksheet Functions | |||
| Excel: Formula worked last week but now stoppped working. | Excel Worksheet Functions | |||
| How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Threaded Mode
