There ios a WEEKNUM function, but it isn't that simple. See

http://www.rondebruin.nl/weeknumber.htm

and

ISO Date Representatation and Week
Numberinghttp://www.rondebruin.nl/isodate.htm
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sorchaainne" wrote in message
...
Hi all
What is the formula (is there a formula) to display the Week number?
Trying to set up a spreadsheet which runs from first to last day of each
month but automatically fills in a 5 week rota.