Hi Niek, thanks for this. However, this seems to return the week of the
year, not month.
"Niek Otten" wrote:
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,
|
|