MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

JAF

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

Mark