Hi There,
I have a spreadsheet containing a list of part numbers, their due date, the due date in terms of Week Number, quantity due and how many weeks away from the current week they are from being due.
I am trying to get the week numbers to continue adding when the year moves from 2010 to 2011 so effectivly I have a part number 60 weeks away rather then -8 weeks away.
Attached is the spreadsheet I am trying to get this implemented for.
Can anyone help?
Thanks