Hey guru's
Scenario:
Shift cycle length = 21 days rotating so after day 21 it goes back to Day 1. (could be a 7 or 14 day cycle)
Shift cycle Start Date on = Jan 1 2017 (can be different dates)
I’m looking for a formulae that can work out what day number in the cycle a future date will map to by using the shift cycle length and a future date.
So using information above I want to be able to enter any future date e.g. 22/1/2017 and using the cycle value = 21 and Shift cycle Start Date = 1/1/17 it work out the 22/1/17 is day 1 in the Shift Cycle.
This is drivng me crazy!
Bookmarks