View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek M[_2_] Derek M[_2_] is offline
external usenet poster
 
Posts: 18
Default =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