Paul, Venkat has given you a solution the gives the 7 days of the Nth week, based on year. Does that solve your need? From what I understood, you just want a validation list from which you can select any day, and the week number of that day will display in the adjacent column. Is that correct?