=today() = weeknumber

  • Thread starter Thread starter Derek M
  • Start date Start date
D

Derek M

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
 
Duh, sussed it =WEEKNUM(A1)

Sorry for the wasted post :)

:
Click to expand...

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
 
Back
Top