| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=today() = weeknumber
Hi all
I wonder if this is possible, in cell A1 e.g. i have =today() Is it possible in cell A2 to get it to calculate and show what week number this is? Thanks as always Derek |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=today() = weeknumber
Duh, sussed it =WEEKNUM(A1)
Sorry for the wasted post :) "Derek M" wrote: Hi all I wonder if this is possible, in cell A1 e.g. i have =today() Is it possible in cell A2 to get it to calculate and show what week number this is? Thanks as always Derek |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=today() = weeknumber
On Fri, 20 Nov 2009 04:25:02 -0800, Derek M
wrote: Duh, sussed it =WEEKNUM(A1) Sorry for the wasted post :) "Derek M" wrote: OK, but keep in mind that Excel's weeknumbers are not computed the same as the ISO standard. So be certain of what you want. If you require ISO weeknumbers, post back for a UDF. --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=today() = weeknumber
For ISO weeknbrs have a look he http://www.cpearson.com/excel/weeknum.htm
Cheers Michael Ron Rosenfeld wrote: On Fri, 20 Nov 2009 04:25:02 -0800, Derek M wrote: Duh, sussed it =WEEKNUM(A1) Sorry for the wasted post :) "Derek M" wrote: OK, but keep in mind that Excel's weeknumbers are not computed the same as the ISO standard. So be certain of what you want. If you require ISO weeknumbers, post back for a UDF. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weeknumber function in vba(excel) doesn't work | Excel Discussion (Misc queries) | |||
| Earliest date using WEEKNUMBER | Excel Worksheet Functions | |||
| weeknumber | Excel Discussion (Misc queries) | |||
| Formula to get the current weeknumber | Excel Discussion (Misc queries) | |||
| Weeknumber in Excel | Excel Discussion (Misc queries) | |||
![Derek M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
