Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Calculate Week Number

Posted by JAF on May 10, 2000 3:32 AM

Hi Folks

I need a formula to generate a week number for the years 1998, 1999 and 2000.

Short of manually creating a list of dates and typing in Week1, Week2 etc, is there an automatic (and hopefully quicker and more simple) way of achieving the same result?

I've checked the online help, but Excel does not appear to have a WEEK function.

Any suggestions appreciated.

JAF

Re: Calculate Week Number

Posted by Mark on May 10, 2000 9:24 AM

JAF

See http://www.cpearson.com/excel/weeknum.htm

Mark

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.