Ok, so the ISOWEEKNUM(A1) works but I need more that just that formula. Here is what I am trying to do... I have a landscaper that wants to pick up flowers that I am growing specifically for him and he wants them on the week of October 2nd. Knowing that his flowers will take 8 weeks to grow, I want excel to calculate what week in the year I should propagate his flowers so they're ready by the week of October 2nd. Does that make sense?