Week by Number

  • Thread starter Thread starter Sue
  • Start date Start date
S

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!
 
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)
 
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.
 
Back
Top