I am trying to figure out a few calculations to perform the following funtions:
1) List the production week - Example: WK 18 falls between 11/7/11 and 11/13/11, Wk 19 falls between dates 11/14/11.
I want to be able to enter a formula that can handle up to 10 WK#'s, checking a field with a...