This page might be a help:
http://www.bygsoftware.com/examples/iso_dates.htm
This page is based on ISO 8601.

It includes the Excel formula and an online week-number calculator using
Microsoft's spreadsheet component.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"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.