I looked at various post to what I'm trying to do, and I could not get
it in my mind as to how to apply some of the answers to what I'm
trying. The info I look at is a user input of "Week1" or "Week2" ect.
I would like to take the "Week1" and convert it to the first week of
the current year which in this case I think would be "29-2" . I need
to take in the account if its a leap year or not. I could use a
vlookup, but would prefer VBA.
Any help would be appreciated.

Thanks