Ok here is a curious question, not even sure if this can be done. I am looking for some VBA code that will look at a date and say what week it is in the month...
Eg: 6/02/2011 - Week1
6/09/2011 - Week2
6/16/2011 - Week3
6/23/2011 - Week4
6/30/2011 - Week5
Eg: 6/02/2011 - Week1
6/09/2011 - Week2
6/16/2011 - Week3
6/23/2011 - Week4
6/30/2011 - Week5