ExcelBanter - convert date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - convert date (https://www.excelbanter.com/excel-worksheet-functions/181338-convert-date.html)

Rui

convert date

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?
--
Thanks in advance!

Mike H

convert date

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

"Rui" wrote:

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?
--
Thanks in advance!

All times are GMT +1. The time now is 08:05 AM.