Date formulas

[Sorchaainne]

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.

 

[Paul Sheppard]

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 o
each
month but automatically fills in a 5 week rota.

Try WEEKNUM functio

 

[Andy Wiggins]

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.

 

[Bob Phillips]

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)