Week by Number

[Sue]

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]

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]

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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.