Work Planner with formula for work rotations

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.

Alcon,

I made an error the modified formula was taken from the rotation-schedule.xlsx under the Rotation_String Tab. Thank you again.

V/r,
Jim

JeteMc,

I entered your formula into my ER_DIV_LIBERTY_LIBERTY TRACKER file and unable to achieve the desired results. I realized that I had not explained my intended results very well. So here is my attempt at a better explanation.

My hope is in cells E13:BH13 to reflect the text sequence in AY3:BG3 with the starting date in BA1:BF1. The current formula in the attached file allows me to show the sequence. It however seems the weekends are not seen by the NETWORKDAYS function so I think whatever character lands of Friday continues through the weekend. I don't care about weekends and holidays (being in the Navy we don't stop working).

I really appreciate your time and effort in looking into this.

The Password for the attached file is "Online". So please open it up and do as you please. Thank you again for your time.

V/r,
Jim

JetMc,

Thank you for your assistance. I had played around with that for a few hours. My grasp of the functions and formulas is weak at best.

V/r,
Jim