Alcon,
I don't know how to modify a formula I used in EXCEL 2010 to operate in a 2007 environment. The following formula:
=MID($AY$3,MOD(NETWORKDAYS.INTL($BA$1,E12,"0000000")-1,LEN($AY$3))+1,1) is used in the attached Excel File named ER_DIV_LIBERTY_LIBERTY TRACKER. I had modified that formula from the other attached file: rotation-schedule.xlsx under the tab Rotation_Advanced.
I don't have a good grasp on formulas on 2007 (or 2010 & on for that matter). I appreciate any help in solving this question.
V/r,
Jim
The ER_DIV_LIBERTY_LIBERTY TRACKER was based on Trevor Easton's Room Booking template and the I used Vertex42 Rotation Schedule Template to build my tracker.
Bookmarks