=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

=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

=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

=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