convert date

[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?

 

[Mike H]

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