Week by Number

Sue · Apr 14, 2004

Does anyone know how to input a formula that will show
the week number? 52 weeks per year, we ship by week
number?

Appreciate the info!

Bob Phillips · Apr 14, 2004

Hi Sue,

It's as easy as

=WEEKNUM(A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Norman Harker · Apr 14, 2004

Hi Sue!

First define your week number algorithm. There are four common ones.
Incidentally, there are more than 52 weeks in a year.

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.