I am trying to determine how to write a formula that allows me to calculate
YTD earnings but I cannot figure how to get the year-to-date to work. I know
how to get the number of weeks from one date to another (for example
8/1/05-4/12/06 = 255 days or 36.43 weeks). My issue is that I want the
formula to count only the weeks YTD 1/1/06-4/12/06. I want the formula to
know that if my begin date is in a prior year to only look at the current
years weeks.

Any assistance would be appreciated. I cannot seem to find an easy solution.