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