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.

Sorchaainne Wrote:
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.

Try WEEKNUM function


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=395633

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.

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.