convert date

  • Thread starter Thread starter Rui
  • Start date Start date
R

Rui

Hello all:
I have a question of how to convert date into week no.in excel 2003?
Example: convert 26-03-2008 to week 13 2008?
 
Hi,

With your date in A1 try this

=WEEKNUM(A1)&" "&YEAR(A1)
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in. Tools|Addins


Mike
 
Back
Top