I'm looking for a formula that will let me see the current week of a rotation based on two dates. Basically, I have a sync date, and a new sync date with a set number of weeks in the rotation--say, 2-weeks, 4-weeks, 12-weeks (whatever) that a routing computer uses to send my technicians to different areas. When I need to update the technician to a new area, I need to see which week of that rotation I'm in. I want to be able to enter this information into excel so it can calculate what the current week rotation is--some of the data I have goes back to 2008, and it makes it very hard to see where the system thinks the current rotation is. I was hoping excel could help, but I'm stuck at coming up with a formula. Many thanks for any assistance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Show current week of rotation between two dates?
Similar threads
- Question
