| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the number of weeks at this moment?
As we know, there is 52 weeks per year, I would like to determine the number
of weeks at this moment. Does anyone have any suggestions on how to determine the number of weeks? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the number of weeks at this moment?
Hi,
Try this =weeknum(TODAY()) If you get a #Name error then Tools|Addins Check the analysis toolpak Mike "Eric" wrote: As we know, there is 52 weeks per year, I would like to determine the number of weeks at this moment. Does anyone have any suggestions on how to determine the number of weeks? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the number of weeks at this moment?
I suggest you look up the WEEKNUM function in help.
Note............need the ATP loaded. Gord Dibben MS Excel MVP On Mon, 15 Sep 2008 03:16:01 -0700, Eric wrote: As we know, there is 52 weeks per year, I would like to determine the number of weeks at this moment. Does anyone have any suggestions on how to determine the number of weeks? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i determine number of weeks between 2 dates | Excel Worksheet Functions | |||
| Please take a moment to Read | New Users to Excel | |||
| Blonde Moment? | Excel Discussion (Misc queries) | |||
| add a number every two weeks | Excel Worksheet Functions | |||
| A few questions if anyone has a moment? | Excel Worksheet Functions | |||
Hybrid Mode
