With your date in A1

=CEILING(DAY(A1)/7,1)




--


Regards,


Peo Sjoblom



"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,