Can anyone help???

I need to create a tape calendar that generates a tape name based on the day and week number for that month. For example:

Today's tape would be Thursday Week x, where x is the week number in the current month (not week number in the year!!)

Also when excel opens the cell pointer moves to the current date.