It depends on what system of week numbering you'd like to use.

Look at this page of Ron de Bruin's site; you'll probably be able to get to a solution from there

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Janet BN" wrote in message ...
| Hi,
|
| Can someone help me with a formula that determines which week of the month a
| specific date falls. i.e. 15/10/07 = Week 3
|
| Thanks,
|
|